<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>FusionCharts For  FileMaker</title>

<link rel="stylesheet" type="text/css" href="FCproFMLibrary.css" />
<style type="text/css">
<!--
.whiteText {color: #FFFFFF}
-->
</style>
</head>
<body>
<table width="98%" border="0" cellspacing="0" cellpadding="3" align="center">
  <tr>
    <td>
      <h2 class="pageHeader">FusionCharts Pro for FileMaker Library : Documentation </h2>    </td>
  </tr>
  <tr>
    <td><div align="left" class="header" ><span class="header1 whiteText">FusionCharts URL Creation Helper Scripts</span></div></td>
  </tr>
  
  <tr>
    <td><table width="100%" cellpadding="5"  cellspacing="1" class="tableAlternate">
      <tbody>
        <tr class="tableAlternateHeader textBold">
          <td width="32%">Script Name</td>
          <td width="68%"><a name="GetFusionChartsFilePath"/><span class="codeInline">GetFusionChartsFilePath</span></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Usage</td>
          <td valign="top" class="text"><p>Can be Referenced/Imported/Copy-Pasted </p>
            <p>Preferred Usage: Referencing</p></td>
        </tr>
        <tr class="tableAlternateDark text">
          <td valign="top" class="textBold">Category</td>
          <td valign="top" class="text">FusionCharts URL Creation Helper Scripts</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Parameters</td>
          <td valign="top" class="text">No Script Parameters</td>
        </tr>
        <tr class="tableAlternateDark text">
          <td valign="top" class="textBold">Description</td>
          <td valign="top" class="text">Returns the path to the FusionCharts html file</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Result</td>
          <td valign="top" class="text">Returns the path to the FusionCharts html file</td>
        </tr>
        <tr class="tableAlternateDark text">
          <td valign="top" class="textBold">Run script with full access privileges</td>
          <td valign="top" class="text">Off</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Include In Menu</td>
          <td valign="top" class="text">No</td>
        </tr>
        <tr class="tableAlternateDark text">
          <td valign="top" class="textBold">Layouts that use this script</td>
          <td valign="top" >
          </td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Scripts that use this script</td>
          <td valign="top" >
          </td>
        </tr>
        <tr class="tableAlternateHeader textBold">
          <td  colspan="2">Script Definition</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Steps</td>
          <td valign="top" class="codeBlock"><ul>
              <li>#Author Infosoft Global(P) Ltd.</li>
            <li>#About the Script</li>
            <li>#----------------------</li>
            <li>#Sets the path to the FusionCharts html file</li>
            <li>#Script Parameters </li>
            <li>#----------------------</li>
            <li>#No script parameters</li>
            <li>#Return Value </li>
            <li>#----------------------</li>
            <li>#Returns the path to the FusionCharts html file</li>
            <li>#Assigns the path to the current directory</li>
            <li>Set Variable [ $currentDir; Value:Let ( folderPath=Left ( Get ( FilePath 
              ) ; Position ( Get ( FilePath ) ; "/" ; Length (Get (FilePath)) ; -1)); 
              Let (curDir=folderPath ; If ( Abs ( Get ( SystemPlatform )) = 2 ; curDir 
              ; Substitute (curDir ; "file:/" ; "file:///Volumes" ) ))) ]</li>
            <li>#Assigns the path to the FusionCharts file</li>
            <li>Set Variable [ $FusionChartsFilePath; Value:$currentDir &amp; "Charts/FusionCharts.html" 
              ]</li>
            <li>Exit Script [ Result: $FusionChartsFilePath ]</li>
          </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Scripts used in this script</td>
          <td valign="top" >
          </td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Pre-requisites for this script</td>
          <td valign="top" >
          </td>
        </tr>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
  <td>
  <table width="100%" class="tableAlternate" cellpadding="5" cellspacing="1">
  <tbody> 
  <tr class="tableAlternateHeader textBold"> 
    <td width="35%">Script Name</td>
    <td width="65%"><a name="InitializeFusionCharts"/>InitializeFusionCharts</td>
  </tr>
  <tr> 
    <td class="textBold">Script Usage</td>
    <td class="text"> 
      <p>Can be Referenced/Imported/Copy-Pasted.</p>
      <p>Preferred Usage: Referencing</p>
    </td>
  </tr>
  <tr class="tableAlternateDark text"> 
    <td class="textBold">Category</td>
    <td class="text">-</td>
  </tr>
  <tr> 
    <td class="textBold" height="40">Script Parameters</td>
    <td class="text" height="40">1. delimiter - (Optional) The delimiter to be 
      used throughout the application. This is an optional parameter. The default 
      value used is ;</td>
  </tr>
  <tr class="tableAlternateDark text"> 
    <td class="textBold">Description</td>
    <td class="text">Initializes FusionCharts. Sets values for globally used variables. 
      Takes care of path differences in Mac OS and Windows.</td>
  </tr>
  <tr> 
    <td class="textBold">Result</td>
    <td class="text">No return value</td>
  </tr>
  <tr class="tableAlternateDark text"> 
    <td class="textBold">Run script with full access privileges</td>
    <td class="text">Off</td>
  </tr>
  <tr> 
    <td class="textBold">Include In Menu</td>
    <td class="text">No</td>
  </tr>
  <tr class="tableAlternateDark text"> 
    <td class="textBold">Layouts that use this script</td>
    <td class="text"> 
      <ul>
      </ul>
    </td>
  </tr>
  <tr> 
    <td class="textBold">Scripts that use this script</td>
    <td class="text"> 
      <ul>
      </ul>
    </td>
  </tr>
  <tr class="tableAlternateHeader textBold"> 
    <td colSpan="2">Script Definition</td>
  </tr>
  <tr> 
    <td class="textBold">Script Steps</td>
    <td class="codeBlock"> 
      <ul>
        <li>#Author InfoSoft Global(P) Ltd.</li>
        <li>#About the Script</li>
        <li>#----------------------</li>
        <li>#Initializes FusionCharts. Sets values for globally used variables.</li>
        <li>#Script Parameters </li>
        <li>#----------------------</li>
        <li>#1. delimiter - (Optional) The delimiter to be used throughout the 
          application. </li>
        <li># This is an optional parameter. The default value used is ;</li>
        <li>#Return Value </li>
        <li>#----------------------</li>
        <li>#No return value</li>
        <li>Set Variable [ $parameters; Value:Get(ScriptParameter) ]</li>
        <li>Set Variable [ $$delimiter; Value:GetValue($parameters;1) ]</li>
        <li>#Assigns the path to the current directory</li>
        <li>Set Variable [ $$currentDir; Value:Let ( folderPath=Left ( Get ( FilePath 
          ) ; Position ( Get ( FilePath ) ; "/" ; Length (Get (FilePath)) ; -1)); 
          Let (curDir=folderPath ; If ( Abs ( Get ( SystemPlatform )) = 2 ; curDir 
          ; Substitute (curDir ; "file:/" ; "file:///Volumes/" ) ))) ]</li>
        <li>#Assigns the path to the FusionCharts file</li>
        <li>Set Variable [ $$FusionChartsFilePath; Value:$$currentDir &amp; "FusionCharts.html" 
          ]</li>
        <li>Set Variable [ $$delimiter; Value:If(IsEmpty($$delimiter);";";$$delimiter) 
          ]</li>
        <li>Exit Script [ Result: True ]</li>
      </ul>
    </td>
  </tr>
  <tr class="tableAlternateDark"> 
    <td class="textBold">Scripts used in this script</td>
    <td class="text"> 
      <ul>
      </ul>
    </td>
  </tr>
  <tr> 
    <td class="textBold">Pre-requisites for this script</td>
    <td class="text"> 
      <ul>
      </ul>
    </td>
  </tr>
  </tbody> 
</table>
  </td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="100%" class="tableAlternate" cellpadding="5" cellspacing="1">
      <tbody>
        <tr class="tableAlternateHeader textBold">
          <td width="32%">Script Name</td>
          <td width=">"><a name="AppendChartParameterToFCURL"/><span class="codeInline">AppendChartParameterToFCURL</span></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Usage</td>
          <td valign="top" class="text"><p>Can be Referenced/Imported/Copy-Pasted.</p>
            <p>Preferred Usage: Referencing</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Category</td>
          <td valign="top" class="text">FusionCharts URL Creation Helper Scripts</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Parameters</td>
          <td valign="top" class="text"><ol>
              <li> ChartType - Type of chart. Takes values like Pie3D, Column3D</li>
            <li> ChartWidth - Width of the chart in pixels </li>
            <li> ChartHeight - Height of the chart in pixel</li>
          </ol></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Description</td>
          <td valign="top" class="text">Appends the QueryString starting with ?, followed by the 
            parameters to the FusionCharts html file path. The File path is got from 
            $$FusionChartsFilePath which is initialized in InitializeFusionCharts script. 
            Also, this script uses the $$delimiter initialized in InitializeFusionCharts 
            script. </td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Result</td>
          <td valign="top" class="text">Returns the new URL with the chart parameters appended to 
            it</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Run script with full access privileges</td>
          <td valign="top" class="text">Off</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Include In Menu</td>
          <td valign="top" class="text">No</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Layouts that use this script</td>
          <td valign="top" >
          </td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Scripts that use this script</td>
          <td valign="top" >
          </td>
        </tr>
        <tr  class="tableAlternateHeader textBold">
          <td colSpan="2" valign="top" >Script Definition</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Steps</td>
          <td valign="top" class="codeInline"><ul>
              <li>#Author InfoSoft Global(P) Ltd.</li>
            <li>#About the Script</li>
            <li>#----------------------</li>
            <li>#Appends the QueryString starting with ?, followed by the parameters 
              to the given address</li>
            <li>#Script Parameters </li>
            <li>#----------------------</li>
            <li>#1. ChartType - Type of chart. Takes values like Pie3D, Column3D </li>
            <li>#2. ChartWidth - Width of the chart in pixels</li>
            <li>#3. ChartHeight - Height of the chart in pixels</li>
            <li>#Return Value </li>
            <li>#----------------------</li>
            <li>#Returns the new URL with the chart parameters appended to it</li>
            <li>Set Variable [ $parameters; Value:Get(ScriptParameter) ]</li>
            <li>Set Variable [ $ChartType; Value:GetValue ( $parameters;1) ]</li>
            <li>Set Variable [ $ChartWidth; Value:GetAsNumber (GetValue ( $parameters;2)) 
              ]</li>
            <li>Set Variable [ $ChartHeight; Value:GetAsNumber (GetValue ( $parameters;3 
              )) ]</li>
            <li>Set Variable [ $WebAddress; Value:$$FusionChartsFilePath ]</li>
            <li>If [ IsEmpty($$FusionChartsFilePath) ]</li>
            <li>#Assigns the path to the current directory</li>
            <li>Set Variable [ $$currentDir; Value:Let ( folderPath=Left ( Get ( FilePath 
              ) ; Position ( Get ( FilePath ) ; "/" ; Length (Get (FilePath)) ; -1)); 
              Let (curDir=folderPath ; If ( Abs ( Get ( SystemPlatform )) = 2 ; curDir 
              ; Substitute (curDir ; "file:/" ; "file:///Volumes/" ) ))) ]</li>
            <li>#Assigns the path to the FusionCharts file</li>
            <li>Set Variable [ $$FusionChartsFilePath; Value:$$currentDir &amp; "FusionCharts.html" 
              ]</li>
            <li>Set Variable [ $$delimiter; Value:If(IsEmpty($$delimiter);";";$$delimiter) 
              ]</li>
            <li>// Show Custom Dialog [ Title: "Message"; Message: "Could not append 
              FCURL : Please initialize FusionCharts first"; Buttons: &ldquo;OK&rdquo;, 
              &ldquo;Cancel&rdquo; ]</li>
            <li>End If</li>
            <li>#Appends the QueryString starting with ?, followed by the parameters</li>
            <li>Set Variable [ $WebAddress; Value: $WebAddress &amp; "?v=3&amp;sep=" 
              &amp;$$delimiter&amp; "&amp;chart=[" &amp; "chartType=" &amp;$ChartType&amp; 
              $$delimiter &amp; "chartWidth=" &amp;$ChartWidth&amp; $$delimiter &amp; 
              "chartHeight=" &amp;$ChartHeight&amp; "]" ]</li>
            <li>#Returns the address with the appended FusionCharts Querystring appended to it</li>
            <li>Exit Script [ Result: $WebAddress ]</li>
          </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Scripts used in this script</td>
          <td valign="top" >
          </td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Pre-requisites for this script</td>
          <td valign="top" >
          </td>
        </tr>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="100%" cellpadding="5" cellspacing="1" class="tableAlternate">
      <tbody>
        <tr class="tableAlternateHeader textBold">
          <td width="32%" valign="top">Script Name</td>
          <td width=">" valign="top"><a name="AppendChartConfigToFCURL"/><span class="codeInline">AppendChartConfigToFCURL</span></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Usage</td>
          <td valign="top" class="text"><p>Can be Referenced/Imported/Copy-Pasted.</p>
            <p>Preferred Usage: Referencing</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Category</td>
          <td valign="top" class="text">FusionCharts URL Creation Helper Scripts</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Parameters</td>
          <td valign="top" class="text"><ol>
              <li> ChartType - Type of chart. Takes values like Pie3D, Column3D</li>
            <li> ChartWidth - Width of the chart in pixels </li>
            <li> ChartHeight - Height of the chart in pixel</li>
            <li> ChartOptions - Other chart parameters like Caption, Sub-Caption separated 
              by delimiter.</li>
          </ol></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Description</td>
          <td valign="top" class="text">Appends the QueryString starting with ?, followed by the 
            chart parameters and the chartParams parameter to the FusionCharts html 
            file path </td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Result</td>
          <td valign="top" class="text">Returns the complete URL with the chart parameters appended 
            to it</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Run script with full access privileges</td>
          <td valign="top" class="text">Off</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Include In Menu</td>
          <td valign="top" class="text">No</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Layouts that use this script</td>
          <td valign="top" >
          </td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Scripts that use this script</td>
          <td valign="top" >
          </td>
        </tr>
        <tr class="tableAlternateHeader textBold">
          <td colSpan="2" valign="top" >Script Definition</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Steps</td>
          <td valign="top" class="codeInline"><ul>
              <li>#Author InfoSoft Global(P) Ltd.</li>
            <li>#About the Script</li>
            <li>#----------------------</li>
            <li>#Appends the QueryString starting with ?, followed by the parameters 
              to the given address</li>
            <li>#And also appends the chartParams parameter</li>
            <li>#This script expects FusionCharts to be initialized</li>
            <li>#If it is not initialized, it initializes it</li>
            <li>#Script Parameters </li>
            <li>#----------------------</li>
            <li>#1. ChartType - Type of chart. Takes values like Pie3D, Column3D </li>
            <li>#2. ChartWidth - Width of the chart in pixels</li>
            <li>#3. ChartHeight - Height of the chart in pixels</li>
            <li>#4. ChartOptions - Other chart parameters like Caption, Sub-Caption </li>
            <li># Sample for this parameter: "caption=Monthly Sales;subCaption=For 
              the entire period;numberPrefix=$" </li>
            <li>#Return Value </li>
            <li>#----------------------</li>
            <li>#Returns the new URL with the chart parameters appended to it</li>
            <li>Set Variable [ $parameters; Value:Get(ScriptParameter) ]</li>
            <li>Set Variable [ $ChartType; Value:GetValue ( $parameters;1) ]</li>
            <li>Set Variable [ $ChartWidth; Value:GetAsNumber (GetValue ( $parameters;2)) 
              ]</li>
            <li>Set Variable [ $ChartHeight; Value:GetAsNumber (GetValue ( $parameters;3 
              )) ]</li>
            <li>Set Variable [ $ChartOptions; Value:GetValue ( $parameters;4 ) ]</li>
            <li>Set Variable [ $WebAddress; Value:$$FusionChartsFilePath ]</li>
            <li>If [ IsEmpty($$FusionChartsFilePath) ]</li>
            <li>#Assigns the path to the current directory</li>
            <li>Set Variable [ $$currentDir; Value:Let ( folderPath=Left ( Get ( FilePath 
              ) ; Position ( Get ( FilePath ) ; "/" ; Length (Get (FilePath)) ; -1)); 
              Let (curDir=folderPath ; If ( Abs ( Get ( SystemPlatform )) = 2 ; curDir 
              ; Substitute (curDir ; "file:/" ; "file:///Volumes/" ) ))) ]</li>
            <li>#Assigns the path to the FusionCharts file</li>
            <li>Set Variable [ $$FusionChartsFilePath; Value:$$currentDir &amp; "FusionCharts.html" 
              ]</li>
            <li>Set Variable [ $$delimiter; Value:If(IsEmpty($$delimiter);";";$$delimiter) 
              ]</li>
            <li>// Show Custom Dialog [ Title: "Message"; Message: "Could not append 
              FCURL : Please initialize FusionCharts first"; Buttons: &ldquo;OK&rdquo;, 
              &ldquo;Cancel&rdquo; ]</li>
            <li>End If</li>
            <li>#Appends the QueryString starting with ?, followed by the parameters</li>
            <li>Set Variable [ $WebAddress; Value: $WebAddress &amp; "?v=3&amp;sep=" 
              &amp;$$delimiter&amp; "&amp;chart=[" &amp; "chartType=" &amp;$ChartType&amp; 
              $$delimiter &amp; "chartWidth=" &amp;$ChartWidth&amp; $$delimiter &amp; 
              "chartHeight=" &amp;$ChartHeight&amp; "]" &amp; "&amp;chartParams=[" 
              &amp; $ChartOptions&amp; "]" ]</li>
            <li>#Returns the address with the appended FusionCharts Querystring appended to it</li>
            <li>Exit Script [ Result: $WebAddress ]</li>
          </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Scripts used in this script</td>
          <td valign="top" >
          </td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Pre-requisites for this script</td>
          <td valign="top" >
          </td>
        </tr>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="100%" class="tableAlternate" cellpadding="5" cellspacing="1">
      <tbody>
        <tr class="tableAlternateHeader textBold">
          <td width="32%" valign="top">Script Name</td>
          <td width="68%" valign="top"><a name="AppendChartParamsParameterToURL"/><span class="codeInline">AppendChartParamsParameterToURL</span></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Usage</td>
          <td valign="top" class="text"><p>Can be Referenced/Imported/Copy-Pasted.</p>
            <p>Preferred Usage: Referencing</p></td>
        </tr>
        <tr class="tableAlternateDark" >
          <td valign="top" class="textBold">Category</td>
          <td valign="top" class="text">FusionCharts URL Creation Helper Scripts</td>
        </tr>
        <tr >
          <td valign="top" class="textBold">Script Parameters</td>
          <td valign="top" class="text"><ol>
              <li> WebAddress - The address to which chart parameter needs to be appended</li>
            <li> ChartParams - This is a delimiter separated set of key- value pairs 
              used to configure the chart.</li>
          </ol></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Description</td>
          <td valign="top" class="text">Appends the QueryString starting with ?, followed by the 
            parameters to the FusionCharts html file path. The File path is got from 
            $$FusionChartsFilePath which is initialized in InitializeFusionCharts script. 
            Also, this scipt uses the $$delimiter initialized in InitializeFusionCharts 
            script. </td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Result</td>
          <td valign="top" class="text">Returns the new URL with the chart parameters appended to 
            it</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Run script with full access privileges</td>
          <td valign="top" class="text">Off</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Include In Menu</td>
          <td valign="top" class="text">No</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Layouts that use this script</td>
          <td valign="top" >
          </td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Scripts that use this script</td>
          <td valign="top" >
          </td>
        </tr>
        <tr class="tableAlternateHeader textBold">
          <td colSpan="2" valign="top">Script Definition</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Steps</td>
          <td valign="top" class="codeInline"><ul>
              <li>#Author InfoSoft Global(P) Ltd.</li>
            <li>#About the Script</li>
            <li>#----------------------</li>
            <li>#Appends the charts parameters to the given address.</li>
            <li>#Here it is assumed that the first block of chart parameters: </li>
            <li>#chartType,chartWidth and chartHeight have been assigned already.</li>
            <li>#The ChartParams parameter provided here is prepended with "&amp;chartParams="</li>
            <li>#And then appended to the Web Address</li>
            <li>#</li>
            <li>#Script Parameters </li>
            <li>#----------------------</li>
            <li>#1. WebAddress - The address to which chart parameter needs to be 
              appended</li>
            <li>#2. ChartParams - This is a delimiter separated set of key- value 
              pairs used to configure the chart.</li>
            <li># There can be several Chart parameters like caption, subcaption, 
              numberPrefix.</li>
            <li># Sample for this parameter: "caption=Monthly Sales;subCaption=For 
              the entire period;numberPrefix=$"</li>
            <li>#Return Value </li>
            <li>#----------------------</li>
            <li>#Returns the new URL with the chartParams parameter appended to it</li>
            <li>Set Variable [ $parameters; Value:Get(ScriptParameter) ]</li>
            <li>Set Variable [ $WebAddress; Value:GetValue ( $parameters;1) ]</li>
            <li>Set Variable [ $ChartParams; Value:GetValue ( $parameters;2) ]</li>
            <li>#Appends the ChartParams to the WebAddress</li>
            <li>Set Variable [ $WebAddress; Value: $WebAddress &amp; "&amp;chartParams=[" 
              &amp; $ChartParams&amp; "]" ]</li>
            <li>#Returns the address with the ChartParams appended to it</li>
            <li>Exit Script [ Result: $WebAddress ]</li>
          </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Scripts used in this script</td>
          <td valign="top" >
          </td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Pre-requisites for this script</td>
          <td valign="top" >
          </td>
        </tr>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="100%" cellpadding="5" cellspacing="1" class="tableAlternate">
      <tbody>
        <tr class="tableAlternateHeader textBold">
          <td width="32%" valign="top">Script Name</td>
          <td width="68%" valign="top"><a name="AppendSSLabelsAndDataToURL"/><span class="codeInline">AppendSSLabelsAndDataToURL</span></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Usage</td>
          <td valign="top" class="text"><p>Can be Referenced/Imported/Copy-Pasted.</p>
            <p>Preferred Usage: Referencing</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Category</td>
          <td valign="top" class="text">FusionCharts URL Creation Helper Scripts</td>
        </tr>
        <tr >
          <td valign="top" class="textBold">Script Parameters</td>
          <td valign="top" class="text"><ol>
              <li> WebAddress - The address to which chart parameter needs to be appended</li>
            <li>labels - The labels to be shown on the chart separated by delimiter</li>
            <li> data - The data to be shown on the chart separated by delimiter</li>
          </ol></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Description</td>
          <td valign="top" class="text">Appends the labels and data parameters to the given Web Address. 
            Appends the corresponding parameter name before each parameter value.</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Result</td>
          <td valign="top" class="text">Returns the new URL with the labels and data parameters appended 
            to it</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Run script with full access privileges</td>
          <td valign="top" class="text">Off</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Include In Menu</td>
          <td valign="top" class="text">No</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Layouts that use this script</td>
          <td valign="top" >
          </td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Scripts that use this script</td>
          <td valign="top" >
              <li><a href="#BuildAndAppendSSDataParams_FromRepetitions">BuildAndAppendSSDataParams - FromRepetitions</a></li>
            <li><a href="#BuildAndAppendSSDataParams_BySummingValuesInLayout">BuildAndAppendSSDataParams - BySummingValuesInLayout</a></li>
            <li><a href="#BuildAndAppendSSDataParams_LoopThroughPortalRow">BuildAndAppendSSDataParams - LoopThroughPortalRows</a></li>
            <li><a href="#BuildAndAppendSSDataParams_LoopThroughPortalInGroups">BuildAndAppendSSDataParams - LoopThroughPortalInGroups</a></li>
            <li><a href="#BuildAndAppendSSDataParams_UsingGetNthRecord">BuildAndAppendSSDataParams-UsingGetNthRecord</a></li>
            <li><a href="#BuildAndAppendSSDataParams_UsingGetNthRecord_UseLabelList">BuildAndAppendSSDataParams-UsingGetNthRecord 
              -UseLabelList</a></li>
            <li><a href="#BuildAndAppendSSDataParams_LoopInGroups_UsingGetNthRecord">BuildAndAppendSSDataParams-LoopInGroups-UsingGetNthRecord</a></li>
          </td>
        </tr>
        <tr  class="tableAlternateHeader textBold">
          <td colSpan="2" valign="top">Script Definition</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Steps</td>
          <td valign="top" class="codeInline"><ul>
              <li>#Author InfoSoft Global(P) Ltd.</li>
            <li>#About the Script</li>
            <li>#----------------------</li>
            <li>#Appends the labels and the data for a Single-Series chart</li>
            <li>#Script Parameters </li>
            <li>#----------------------</li>
            <li>#1. WebAddress - The address to which chart parameter needs to be 
              appended</li>
            <li>#2. labels - The labels to be shown on the chart separated by delimiter</li>
            <li>#3. data - The data to be shown on the chart separated by delimiter</li>
            <li>#Return Value </li>
            <li>#----------------------</li>
            <li>#Returns the new URL with the labels and data appended to it</li>
            <li>Set Variable [ $parameters; Value:Get(ScriptParameter) ]</li>
            <li>Set Variable [ $WebAddress; Value:GetValue ( $parameters;1) ]</li>
            <li>Set Variable [ $labels; Value:GetValue ( $parameters;2) ]</li>
            <li>Set Variable [ $data; Value:GetValue ( $parameters;3) ]</li>
            <li>#Appends the labels and data by prepending them with their parameter 
              names</li>
            <li>Set Variable [ $WebAddress; Value: $WebAddress &amp; "&amp;labels=" 
              &amp; $labels &amp; "&amp;data=" &amp; $data ]</li>
            <li>#Returns the address with the appended labels and data</li>
            <li>Exit Script [ Result: $WebAddress ]</li>
          </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Scripts used in this script</td>
          <td valign="top" >
          </td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Pre-requisites for this script</td>
          <td valign="top" class="text"> WebAddress parameter already has first set of parameters 
            in the QueryString starting with ?. </td>
        </tr>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="100%" cellpadding="5" cellspacing="1" class="tableAlternate">
      <tbody>
        <tr class="tableAlternateHeader textBold">
          <td width="32%" valign="top">Script Name</td>
          <td width="68%" valign="top"><a name="AppendLabelsToURL"/><span class="codeInline">AppendLabelsToURL</span></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Usage</td>
          <td valign="top" class="text"><p>Can be Referenced/Imported/Copy-Pasted.</p>
            <p>Preferred Usage: Referencing</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Category</td>
          <td valign="top" class="text">FusionCharts URL Creation Helper Scripts</td>
        </tr>
        <tr >
          <td valign="top" class="textBold">Script Parameters</td>
          <td valign="top" class="text"><ol>
              <li>WebAddress - The address to which chart parameter needs to be appended</li>
            <li> labels - The labels to be shown on the chart separated by delimiter</li>
          </ol></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Description</td>
          <td valign="top" class="text">Appends the labels parameter to the given Web Address. Appends 
            the corresponding parameter name before the parameter value.</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Result</td>
          <td valign="top" class="text">Returns the new URL with the labels appended to it</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Run script with full access privileges</td>
          <td valign="top" class="text">Off</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Include In Menu</td>
          <td valign="top" class="text">No</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Layouts that use this script</td>
          <td valign="top" >
          </td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Scripts that use this script</td>
          <td valign="top" >
              <li><a href="#AppendLabelsFromValueList">AppendLabelsFromValueList</a></li>
          </td>
        </tr>
        <tr class="tableAlternateHeader textBold">
          <td colSpan="2" valign="top" >Script Definition</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Steps</td>
          <td valign="top" class="codeInline"><ul>
              <li>#Author InfoSoft Global(P) Ltd.</li>
            <li>#About the Script</li>
            <li>#----------------------</li>
            <li>#Appends the labels to the URL</li>
            <li>#Script Parameters </li>
            <li>#----------------------</li>
            <li>#1. WebAddress - The address to which chart parameter needs to be 
              appended</li>
            <li>#2. labels - The labels to be shown on the chart separated by delimiter</li>
            <li>#Return Value </li>
            <li>#----------------------</li>
            <li>#Returns the new URL with the labels appended to it</li>
            <li>Set Variable [ $parameters; Value:Get(ScriptParameter) ]</li>
            <li>Set Variable [ $WebAddress; Value:GetValue ( $parameters;1) ]</li>
            <li>Set Variable [ $labels; Value:GetValue ( $parameters;2) ]</li>
            <li>#Appends the labels and data by prepending them with their parameter 
              names</li>
            <li>Set Variable [ $WebAddress; Value: $WebAddress &amp; "&amp;labels=" 
              &amp; $labels ]</li>
            <li>#Returns the address with the appended labels and data</li>
            <li>Exit Script [ Result: $WebAddress ]</li>
          </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Scripts used in this script</td>
          <td valign="top" >
          </td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Pre-requisites for this script</td>
          <td valign="top" class="text">WebAddress parameter already has first set of parameters in the QueryString 
            starting with ?. </td>
        </tr>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="100%" cellpadding="5" cellspacing="1" class="tableAlternate">
      <tbody>
        <tr class="tableAlternateHeader textBold">
          <td width="32%" valign="top">Script Name</td>
          <td width="68%" valign="top"><a name="AppendStyleDefParameterToURL"/><span class="codeInline">AppendStyleDefParameterToURL</span></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Usage</td>
          <td valign="top" class="text"><p>Can be Referenced/Imported/Copy-Pasted.</p>
            <p>Preferred Usage: Referencing</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Category</td>
          <td valign="top" class="text">FusionCharts URL Creation Helper Scripts</td>
        </tr>
        <tr >
          <td valign="top" class="textBold">Script Parameters</td>
          <td valign="top" class="text"><ol>
              <li>WebAddress - The address to which chart parameter needs to be appended</li>
            <li> StyleDefValue - This is a value for the styleDef parameter</li>
          </ol>
              <ul>
                <li>Block of values. Each block enclosed in square brackets. Each parameter 
                  seaprated by delimiter</li>
                <li>Sample for this parameter: "[name=captionStyle;type=font;size=14;font=Arial]</li>
                <li>[name=subCaptionStyle;type=font;size=12;font=Arial]"</li>
            </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Description</td>
          <td valign="top" class="text">Appends the styleDef parameter to the given Web Address. 
            Appends the corresponding parameter name before the parameter value.</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Result</td>
          <td valign="top" class="text">Returns the new URL with the styleDef parameter appended 
            to it</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Run script with full access privileges</td>
          <td valign="top" class="text">Off</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Include In Menu</td>
          <td valign="top" class="text">No</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Layouts that use this script</td>
          <td valign="top" >
          </td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Scripts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr class="tableAlternateHeader textBold">
          <td colSpan="2" valign="top">Script Definition</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Steps</td>
          <td valign="top" class="codeInline"><ul>
              <li>#Author InfoSoft Global(P) Ltd.</li>
            <li>#About the Script</li>
            <li>#----------------------</li>
            <li>#Appends the styleDef parameter to the given address.</li>
            <li>#Here it is assumed that some parameters have already been assigned 
              to the WebAddress</li>
            <li>#The parameter name and value are appended to the WebAddress</li>
            <li>#in the format "&amp; styleDef=" &amp; $StyleDefValue</li>
            <li>#And then appended to the Web Address</li>
            <li>#</li>
            <li>#Script Parameters </li>
            <li>#----------------------</li>
            <li>#1. WebAddress - The address to which chart parameter needs to be 
              appended</li>
            <li>#2. StyleDefValue - This is a value for the styleDef parameter </li>
            <li># Block of values. Each block enclosed in square brackets. Each parameter 
              seaprated by delimiter</li>
            <li># Sample for this parameter: "[name=captionStyle;type=font;size=14;font=Arial]</li>
            <li># [name=subCaptionStyle;type=font;size=12;font=Arial]"</li>
            <li>#Return Value </li>
            <li>#----------------------</li>
            <li>#Returns the new URL with the styleDef parameter appended to it</li>
            <li>Set Variable [ $parameters; Value:Get(ScriptParameter) ]</li>
            <li>Set Variable [ $WebAddress; Value:GetValue ( $parameters;1) ]</li>
            <li>Set Variable [ $StyleDefValue; Value:GetValue ( $parameters;2) ]</li>
            <li>#Appends the given parameter to the WebAddress</li>
            <li>Set Variable [ $WebAddress; Value: $WebAddress &amp; "&amp;styleDef=" 
              &amp;$StyleDefValue ]</li>
            <li>#Returns the address with the given parameter appended to it</li>
            <li>Exit Script [ Result: $WebAddress ]</li>
          </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Scripts used in this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Pre-requisites for this script</td>
          <td valign="top" class="text">WebAddress parameter already has first set of parameters in the QueryString 
            starting with ?. </td>
        </tr>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="100%" cellpadding="5" cellspacing="1" class="tableAlternate">
      <tbody>
        <tr class="tableAlternateHeader textBold">
          <td width="32%" valign="top">Script Name</td>
          <td width="68%" valign="top"><a name="AppendStyleAppParameterToURL"/><span class="codeInline">AppendStyleAppParameterToURL</span></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Usage</td>
          <td valign="top" class="text"><p>Can be Referenced/Imported/Copy-Pasted.</p>
            <p>Preferred Usage: Referencing</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Category</td>
          <td valign="top" class="text">FusionCharts URL Creation Helper Scripts</td>
        </tr>
        <tr >
          <td valign="top" class="textBold">Script Parameters</td>
          <td valign="top" class="text"><ol>
              <li>WebAddress - The address to which chart parameter needs to be appended</li>
            <li> StyleAppValue - This is a value for the styleApp parameter </li>
          </ol>
              <ul>
                <li>Block of values. Each block enclosed in square brackets. Each parameter 
                  seaprated by delimiter</li>
                <li>Sample for this parameter: "[toobject=caption;styles=captionStyle]</li>
                <li> [toobject=subcaption;styles=subCaptionStyle]"</li>
            </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Description</td>
          <td valign="top" class="text">Appends the styleApp parameter to the given Web Address. 
            Appends the corresponding parameter name before the parameter value.</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Result</td>
          <td valign="top" class="text">Returns the new URL with the styleApp parameter appended 
            to it</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Run script with full access privileges</td>
          <td valign="top" class="text">Off</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Include In Menu</td>
          <td valign="top" class="text">No</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Layouts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Scripts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr class="tableAlternateHeader textBold">
          <td colSpan="2" valign="top" >Script Definition</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Steps</td>
          <td valign="top" class="codeInline"><ul>
              <li>#Author InfoSoft Global(P) Ltd.</li>
            <li>#About the Script</li>
            <li>#----------------------</li>
            <li>#Appends the styleDef parameter to the given address.</li>
            <li>#Here it is assumed that some parameters have already been assigned 
              to the WebAddress</li>
            <li>#The parameter name and value are appended to the WebAddress</li>
            <li>#in the format "&amp; styleApp=" &amp; $StyleDefValue</li>
            <li>#And then appended to the Web Address</li>
            <li>#</li>
            <li>#Script Parameters </li>
            <li>#----------------------</li>
            <li>#1. WebAddress - The address to which chart parameter needs to be 
              appended</li>
            <li>#2. StyleAppValue - This is a value for the styleApp parameter </li>
            <li># Block of values. Each block enclosed in square brackets. Each parameter 
              seaprated by delimiter</li>
            <li># Sample for this parameter: "[toobject=caption;styles=captionStyle]</li>
            <li># [toobject=subcaption;styles=subCaptionStyle]"</li>
            <li>#Return Value </li>
            <li>#----------------------</li>
            <li>#Returns the new URL with the styleApp parameter appended to it</li>
            <li>Set Variable [ $parameters; Value:Get(ScriptParameter) ]</li>
            <li>Set Variable [ $WebAddress; Value:GetValue ( $parameters;1) ]</li>
            <li>Set Variable [ $StyleAppValue; Value:GetValue ( $parameters;2) ]</li>
            <li>#Appends the given parameter to the WebAddress</li>
            <li>Set Variable [ $WebAddress; Value: $WebAddress &amp; "&amp;styleApp=" 
              &amp;$StyleAppValue ]</li>
            <li>#Returns the address with the given parameter appended to it</li>
            <li>Exit Script [ Result: $WebAddress ]</li>
          </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Scripts used in this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Pre-requisites for this script</td>
          <td valign="top" class="text">WebAddress parameter already has first set of parameters in the QueryString 
            starting with ?. </td>
        </tr>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="100%" cellpadding="5" cellspacing="1" class="tableAlternate">
      <tbody>
        <tr class="tableAlternateHeader textBold">
          <td width="32%" valign="top">Script Name</td>
          <td width="68%" valign="top"><a name="AppendAnyParameterToURL"/><span class="codeInline">AppendAnyParameterToURL</span></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Usage</td>
          <td valign="top" class="text"><p>Can be Referenced/Imported/Copy-Pasted.</p>
            <p>Preferred Usage: Referencing</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Category</td>
          <td valign="top" class="text">FusionCharts URL Creation Helper Scripts</td>
        </tr>
        <tr >
          <td valign="top" class="textBold">Script Parameters</td>
          <td valign="top" class="text"><ol>
              <li>WebAddress - The address to which chart parameter needs to be appended</li>
            <li>ParameterName - This is a name of the parameter to be appended</li>
            <ul>
                <li> Sample for this parameter: "styleDef"</li>
            </ul>
            <li> ParameterValue - This is a value for the parameter</li>
            <ul>
              <li>Sample for this parameter: "[name=captionStyle;type=font;size=14;font=Arial]
                [name=subCaptionStyle;type=font;size=12;font=Arial]"</li>
            </ul>
          </ol></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Description</td>
          <td valign="top" class="text">Appends the given parameter to the given Web Address. Appends 
            the corresponding parameter name before the parameter value.</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Result</td>
          <td valign="top" class="text">Returns the new URL with the given parameter appended to 
            it</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Run script with full access privileges</td>
          <td valign="top" class="text">Off</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Include In Menu</td>
          <td valign="top" class="text">No</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Layouts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Scripts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr class="tableAlternateHeader textBold">
          <td colSpan="2" valign="top">Script Definition</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Steps</td>
          <td valign="top" class="codeInline"><ul>
              <li>#Author InfoSoft Global(P) Ltd.</li>
            <li>#About the Script</li>
            <li>#----------------------</li>
            <li>#Appends the charts parameters to the given address.</li>
            <li>#Here it is assumed that the first block of chart parameters: </li>
            <li>#chartType,chartWidth and chartHeight have been assigned already.</li>
            <li>#The parameter name and value are appended to the WebAddress</li>
            <li>#in the format "&amp;"&amp; $ParameterName &amp;"=" &amp; $ParameterValue</li>
            <li>#And then appended to the Web Address</li>
            <li>#</li>
            <li>#Script Parameters </li>
            <li>#----------------------</li>
            <li>#1. WebAddress - The address to which chart parameter needs to be 
              appended</li>
            <li>#2. ParameterName - This is a name of the parameter to be appended</li>
            <li># Sample for this parameter: "styleDef"</li>
            <li>#3. ParameterValue - This is a value for the parameter</li>
            <li># Sample for this parameter: "[name=captionStyle;type=font;size=14;font=Arial]</li>
            <li># [name=subCaptionStyle;type=font;size=12;font=Arial]"</li>
            <li>#Return Value </li>
            <li>#----------------------</li>
            <li>#Returns the new URL with the given parameter appended to it</li>
            <li>Set Variable [ $parameters; Value:Get(ScriptParameter) ]</li>
            <li>Set Variable [ $WebAddress; Value:GetValue ( $parameters;1) ]</li>
            <li>Set Variable [ $ParameterName; Value:GetValue ( $parameters;2) ]</li>
            <li>Set Variable [ $ParameterValue; Value:GetValue ( $parameters;3) ]</li>
            <li>#Appends the given parameter to the WebAddress</li>
            <li>Set Variable [ $WebAddress; Value: $WebAddress &amp; "&amp;" &amp;$ParameterName&amp; 
              "=" &amp;$ParameterValue ]</li>
            <li>#Returns the address with the given parameter appended to it</li>
            <li>Exit Script [ Result: $WebAddress ]</li>
          </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Scripts used in this script</td>
          <td valign="top" class="regularcharttext"><ul>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Pre-requisites for this script</td>
          <td valign="top" class="text">WebAddress parameter already has first set of parameters in the QueryString 
            starting with ?. </td>
        </tr>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div align="left" class="header" ><span class="header1 whiteText">FusionCharts Utility Scripts</span></div> </td>
  </tr>
  <tr>
    <td><table width="100%" cellpadding="5" cellspacing="1" class="tableAlternate">
      <tbody>
        <tr class="tableAlternateHeader textBold">
          <td width="32%" valign="top">Script Name</td>
          <td width="68%" valign="top"><a name="EscapePercentAndForwardSlashCharacters"/><span class="codeInline">EscapePercentAndForwardSlashCharacters</span></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Usage</td>
          <td valign="top" class="text"><p>Can be Referenced/Imported/Copy-Pasted.</p>
              <p>Preferred Usage: Referencing</p>
            <p>Note that this script should be used only when percent character <b>and</b> forward slash character has to be escaped.</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Category</td>
          <td valign="top" class="text">FusionCharts Utility Scripts</td>
        </tr>
        <tr >
          <td valign="top" class="textBold">Script Parameters</td>
          <td valign="top" class="text"><ol>
              <li>text - The text which needs to be escaped</li>
          </ol></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Description</td>
          <td valign="top" class="text">Escapes the special characters <span class="codeInline">%</span> and <span class="codeInline">/</span> in the given text and returns the 
            escaped text. </td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Result</td>
          <td valign="top" class="text">Returns the escaped text</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Run script with full access privileges</td>
          <td valign="top" class="text">Off</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Include In Menu</td>
          <td valign="top" class="text">No</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Layouts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Scripts that use this script</td>
          <td valign="top" class="text"><ul>
              <li><a href="#BuildAndAppendSSDataParams_BySummingValuesInLayout">BuildAndAppendSSDataParams - BySummingValuesInLayout</a></li>
          </ul></td>
        </tr>
        <tr class="tableAlternateHeader textBold">
          <td colspan="2" valign="top">Script Definition</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Steps</td>
          <td valign="top" class="codeInline"><ul>
              <li>#Author InfoSoft Global(P) Ltd.</li>
            <li>#About the Script</li>
            <li>#----------------------</li>
            <li>#Escapes the % and / special characters which when used within parameter 
              values, can cause trouble.</li>
            <li>#</li>
            <li>#Script Parameters </li>
            <li>#----------------------</li>
            <li>#The text which needs to be escaped</li>
            <li>#Return Value </li>
            <li>#----------------------</li>
            <li>#Returns the new text with the % and / special characters escaped</li>
            <li>Set Variable [ $parameters; Value:Get(ScriptParameter) ]</li>
            <li>Set Variable [ $text; Value:GetValue ( $parameters;1) ]</li>
            <li>Set Variable [ $text; Value:Substitute($text;"%";"%2525") ]</li>
            <li>Set Variable [ $text; Value:Substitute($text;"/";"%252f") ]</li>
            <li>Exit Script [ Result: $text ]</li>
          </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Scripts used in this script</td>
          <td valign="top" class="regularcharttext"><ul>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Pre-requisites for this script</td>
          <td valign="top" class="text"> No special character in the text should already be escaped, 
            otherwise the script may return unexpected results.
            <ul>
            </ul></td>
        </tr>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="100%" cellpadding="5" cellspacing="1" class="tableAlternate">
      <tbody>
        <tr class="tableAlternateHeader textBold">
          <td width="32%" valign="top">Script Name</td>
          <td width="68%" valign="top"><a name="EscapeAllSpecialCharacters"/><span class="codeInline">EscapeAllSpecialCharacters</span></td>
        </tr>
        <tr>
          <td width="32%" height="471" valign="top" class="textBold">Script Usage</td>
          <td width="68%" height="471" valign="top" class="text"><p>Can be Referenced/Imported/Copy-Pasted.</p>
              <p>Preferred Usage: Referencing</p>
            <p>Note that this script should be used only when all the below listed characters 
              need to be escaped:</p>
            <table border="0" cellspacing="1" cellpadding="0" class="tableAlternate text">
                <tr class="tableAlternateHeader textBold">
                  <td width="145" valign="top" class="textBold"><p>Character </p></td>
                  <td width="189" valign="top" class="textBold"><p>Encoded Form</p></td>
                </tr>
                <tr>
                  <td valign="top" width="145">&cent;</td>
                  <td valign="top" width="189">%25a2</td>
                </tr>
                <tr class="tableAlternateDark">
                  <td valign="top" width="145">&pound;</td>
                  <td valign="top" width="189">%25a3</td>
                </tr>
                <tr>
                  <td valign="top" width="145">&yen;</td>
                  <td valign="top" width="189">%25a5</td>
                </tr>
                <tr class="tableAlternateDark">
                  <td width="145" valign="top"><p>#</p></td>
                  <td width="189" valign="top"><p>%2523</p></td>
                </tr>
                <tr>
                  <td width="145" valign="top"><p>[</p></td>
                  <td width="189" valign="top"><p>%255b</p></td>
                </tr>
                <tr>
                  <td width="145" valign="top" class="tableAlternateDark"><p>&amp;</p></td>
                  <td width="189" valign="top" class="tableAlternateDark"><p>%2526</p></td>
                </tr>
                <tr>
                  <td valign="top &gt;&lt;p&gt;?&lt;/p&gt;&lt;/td&gt;
        &lt;td valign="top="top" width="145"><p class="text">?</p></td>
                  <td width="189" valign="top"><p>%253f</p></td>
                </tr>
                <tr>
                  <td width="145" valign="top" class="tableAlternateDark"><p>;</p></td>
                  <td width="189" valign="top" class="tableAlternateDark"><p>%253b</p></td>
                </tr>
                <tr>
                  <td width="145" valign="top"><p>&gt;&nbsp;</p></td>
                  <td width="189" valign="top"><p>%2526gt%253b</p></td>
                </tr>
                <tr>
                  <td valign="top" class="tableAlternateDark" width="145">/</td>
                  <td valign="top" class="tableAlternateDark" width="189">%252f</td>
                </tr>
              </table>
            <p>&nbsp;</p>
            <table border="0" cellspacing="1" cellpadding="0" class="tableAlternate text">
                <tr class="tableAlternateHeader textBold">
                  <td width="145" valign="top" class="textBold"><p>Character</p></td>
                  <td width="190" valign="top" class="textBold"><p>Encoded Form</p></td>
                </tr>
                <tr>
                  <td valign="top">&euro;</td>
                  <td valign="top">%25e2%2582%25ac </td>
                </tr>
                <tr class="tableAlternateDark">
                  <td valign="top">&#8355;</td>
                  <td valign="top">%25e2%2582%25a3</td>
                </tr>
                <tr>
                  <td valign="top">%</td>
                  <td valign="top">%2525</td>
                </tr>
                <tr class="tableAlternateDark">
                  <td width="145" valign="top"><p>|</p></td>
                  <td width="190" valign="top"><p>%257c</p></td>
                </tr>
                <tr>
                  <td width="145" valign="top"><p>]</p></td>
                  <td width="190" valign="top"><p>%255d</p></td>
                </tr>
                <tr>
                  <td width="145" valign="top" class="tableAlternateDark"><p>@ </p></td>
                  <td width="190" valign="top" class="tableAlternateDark"><p>%2540</p></td>
                </tr>
                <tr>
                  <td width="145" valign="top"><p>+</p></td>
                  <td width="145" valign="top"><p>%252b</p></td>
                </tr>
                <tr>
                  <td width="145" valign="top" class="tableAlternateDark"><p>=</p></td>
                  <td width="190" valign="top" class="tableAlternateDark"><p>%253d</p></td>
                </tr>
                <tr>
                  <td valign="top"><p>&lt;</p></td>
                  <td valign="top"><p>%2526lt%253b</p></td>
                </tr>
                <tr>
                  <td valign="top" class="tableAlternateDark">\</td>
                  <td valign="top" class="tableAlternateDark">%255c</td>
                </tr>
              </table>
            <p>&nbsp;</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td width="32%" valign="top" class="textBold">Category</td>
          <td width="68%" valign="top" class="text">FusionCharts URL Utility Scripts</td>
        </tr>
        <tr >
          <td width="32%" valign="top" class="textBold">Script Parameters</td>
          <td width="68%" valign="top" class="text"><ol>
              <li>text - The text which needs to be escaped</li>
          </ol></td>
        </tr>
        <tr class="tableAlternateDark">
          <td width="32%" valign="top" class="textBold">Description</td>
          <td width="68%" valign="top" class="text">Escapes the special characters in the given text 
            and returns the escaped text. </td>
        </tr>
        <tr>
          <td width="32%" valign="top" class="textBold">Result</td>
          <td width="68%" valign="top" class="text">Returns the escaped text</td>
        </tr>
        <tr class="tableAlternateDark">
          <td width="32%" valign="top" class="textBold">Run script with full access privileges</td>
          <td width="68%" valign="top" class="text">Off</td>
        </tr>
        <tr>
          <td width="32%" valign="top" class="textBold">Include In Menu</td>
          <td width="68%" valign="top" class="text">No</td>
        </tr>
        <tr class="tableAlternateDark">
          <td width="32%" valign="top" class="textBold">Layouts that use this script</td>
          <td width="68%" valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr>
          <td width="32%" valign="top" class="textBold">Scripts that use this script</td>
          <td width="68%" valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr class="tableAlternateHeader textBold">
          <td colspan="2" valign="top">Script Definition</td>
        </tr>
        <tr>
          <td width="32%" valign="top" class="textBold">Script Steps</td>
          <td width="68%" valign="top" class="codeInline"><ul>
              <li>#Author InfoSoft Global(P) Ltd.</li>
            <li>#About the Script</li>
            <li>#----------------------</li>
            <li>#Escapes the special characters which when used within parameter values, 
              can cause trouble.</li>
            <li>#</li>
            <li>#Script Parameters </li>
            <li>#----------------------</li>
            <li>#The text which needs to be escaped</li>
            <li>#Return Value </li>
            <li>#----------------------</li>
            <li>#Returns the new text with the special characters escaped</li>
            <li>Set Variable [ $parameters; Value:Get(ScriptParameter) ]</li>
            <li>Set Variable [ $text; Value:GetValue ( $parameters;1) ]</li>
            <li>Set Variable [ $text; Value:Substitute($text;"%";"%2525") ]</li>
            <li>Set Variable [ $text; Value:Substitute($text;"/";"%252f") ]</li>
            <li>Set Variable [ $text; Value:Substitute($text;"#";"%2523") ]</li>
            <li>Set Variable [ $text; Value:Substitute($text;"&amp;";"%2526") ]</li>
            <li>Set Variable [ $text; Value:Substitute($text;";";"%253b") ]</li>
            <li>Set Variable [ $text; Value:Substitute($text;"=";"%253d") ]</li>
            <li>Set Variable [ $text; Value:Substitute($text;"&gt;";"%253e") ]</li>
            <li>Set Variable [ $text; Value:Substitute($text;"?";"%253f") ]</li>
            <li>Set Variable [ $text; Value:Substitute($text;"&lt;";"%2526lt%253b") 
              ]</li>
            <li>Set Variable [ $text; Value:Substitute($text;"@";"%2540") ]</li>
            <li>Set Variable [ $text; Value:Substitute($text;"[";"%255b") ]</li>
            <li>Set Variable [ $text; Value:Substitute($text;"]";"%255d") ]</li>
            <li>Set Variable [ $text; Value:Substitute($text;"|";"%257c") ]</li>
            <li>Set Variable [ $text; Value:Substitute($text;"+";"%252b") ]</li>
            <li>Set Variable [ $text; Value:Substitute($text;"&cent;";"%25a2") ]</li>
            <li>Set Variable [ $text; Value:Substitute($text;"&pound;";"%25a3") ]</li>
            <li>Set Variable [ $text; Value:Substitute($text;"&yen;";"%25a5") ]</li>
            <li>Set Variable [ $text; Value:Substitute($text;"&euro;";"%25E2%2582%25AC") 
              ]</li>
            <li>Set Variable [ $text; Value:Substitute($text;"₣";"%25E2%2582%25A3") 
              ]</li>
            <li>Exit Script [ Result: $text ]</li>
          </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td width="32%" valign="top" class="textBold">Scripts used in this script</td>
          <td width="68%" valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr>
          <td width="32%" valign="top" class="textBold">Pre-requisites for this script</td>
          <td width="68%" valign="top" class="text"> No special character in the text should already 
            be escaped, otherwise the script may return unexpected results.
            <ul>
            </ul></td>
        </tr>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="100%" cellpadding="5" cellspacing="1" class="tableAlternate">
      <tbody>
        <tr class="tableAlternateHeader text">
          <td width="32%" valign="top"><strong>Script Name</strong></td>
          <td width="68%" valign="top" ><a name="ReplaceValueInAList"/><span class="codeInline">ReplaceValueInAList</span></td>
        </tr>
        <tr>
          <td height="47" valign="top" class="textBold">Script Usage</td>
          <td height="47" valign="top" class="text"><p>Can be Referenced/Imported/Copy-Pasted.</p>
            <p>Preferred Usage: Referencing</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Category</td>
          <td valign="top" class="text">FusionCharts Utility Scripts</td>
        </tr>
        <tr >
          <td valign="top" class="textBold">Script Parameters</td>
          <td valign="top" class="text"><ol>
              <li> quotedlist - The list which is present within quotes and in which 
                the value has to be replaced.</li>
            <li>position - The position in the list at which the new value needs to 
              be put</li>
            <li> NewValue - The new value that has to replace the existing value</li>
          </ol></td>
        </tr>
        <tr class="tableAlternateDark">
          <td height="36" valign="top" class="textBold">Description</td>
          <td height="36" valign="top" class="text">Replaces the value present at a given position 
            in a list, with the new value</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Result</td>
          <td valign="top" class="text">Returns the new list (within quotes)</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Run script with full access privileges</td>
          <td valign="top" class="text">Off</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Include In Menu</td>
          <td valign="top" class="text">No</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Layouts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Scripts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr class="tableAlternateHeader textBold">
          <td colspan="2" valign="top">Script Definition</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Steps</td>
          <td valign="top" class="codeInline"><ul>
              <li>#Author InfoSoft Global(P) Ltd.</li>
            <li>#About the Script</li>
            <li>#----------------------</li>
            <li>#Replaces the value present at a position</li>
            <li>#in a list, with the new value</li>
            <li>#Script Parameters </li>
            <li>#----------------------</li>
            <li>#1. quotedlist - The list which is present within quotes.</li>
            <li>#2. position - The position at which new value needs to be put</li>
            <li>#3. NewValue - The new value that has to replace the existing value</li>
            <li>#Return Value </li>
            <li>#----------------------</li>
            <li>#Returns the new list (within quotes)</li>
            <li>#appended to the given web address</li>
            <li>Set Variable [ $parameters; Value:Get(ScriptParameter) ]</li>
            <li>Set Variable [ $quotedlist; Value:GetValue($parameters;1) ]</li>
            <li>Set Variable [ $position; Value:GetAsNumber(GetValue($parameters;2)) 
              ]</li>
            <li>Set Variable [ $NewValue; Value:GetValue($parameters;3) ]</li>
            <li>Set Variable [ $i; Value:1 ]</li>
            <li>Set Variable [ $list; Value:Evaluate($quotedlist) ]</li>
            <li>Loop</li>
            <li>Exit Loop If [ $i&gt;ValueCount ( $list ) ]</li>
            <li>If [ $i &ne; $position ]</li>
            <li>Set Variable [ $newList; Value:If ($i &ne; 1 ;$newList &amp; "&para;";"") 
              &amp; GetValue($list;$i) ]</li>
            <li>Else</li>
            <li>Set Variable [ $newList; Value:If ($i &ne; 1 ;$newList &amp; "&para;";"") 
              &amp; $NewValue ]</li>
            <li>End If</li>
            <li>Set Variable [ $i; Value:$i+1 ]</li>
            <li>End Loop</li>
            <li>Exit Script [ Result: Quote($newList) ]</li>
          </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Scripts used in this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr>
          <td class="textBold" valign="top" height="36">Pre-requisites for this script</td>
          <td height="36" valign="top" class="text"><ul>
          </ul></td>
        </tr>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div align="left" class="header" ><span class="header1 whiteText">FusionCharts Data Parameters Helper Scripts</span></div></td>
  </tr>
  <tr>
    <td><table width="100%" cellpadding="5" cellspacing="1" class="tableAlternate">
      <tbody>
        <tr class="tableAlternateHeader textBold">
          <td width="32%" valign="top">Script Name</td>
          <td width="68%" valign="top"><a name="AppendLabelsFromValueList"/><span class="codeInline">AppendLabelsFromValueList</span></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Usage</td>
          <td valign="top" class="text"><p>Can be Referenced/Imported/Copy-Pasted.</p>
            <p>Preferred Usage: Referencing</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Category</td>
          <td valign="top" class="text">FusionCharts Data Parameters Helper Scripts</td>
        </tr>
        <tr >
          <td valign="top" class="textBold">Script Parameters</td>
          <td valign="top" class="text"><ol>
              <li> WebAddress - The URL to which data parameters have to be appended</li>
            <li> LabelListName - The Value List which has to be used for labels</li>
            <li> FileName - The FileName where Value List is present</li>
            <li> delimiter - (Optional) The delimiter to be used in this script. This 
              is an optional parameter. The default value used is the one specified 
              in global values when FusionCharts is initialized.</li>
          </ol></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Description</td>
          <td valign="top" class="text">Appends the labels from the Value List to the given URL</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Result</td>
          <td valign="top" class="text"><p>Returns the new web address with the labels appended to the given web 
            address</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Run script with full access privileges</td>
          <td valign="top" class="text">Off</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Include In Menu</td>
          <td valign="top" class="text">No</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Layouts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Scripts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr class="tableAlternateHeader textBold">
          <td colspan="2" valign="top">Script Definition</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Steps</td>
          <td valign="top" class="codeInline"><ul>
              <li>#Author InfoSoft Global(P) Ltd.</li>
            <li>#About the Script</li>
            <li>#----------------------</li>
            <li>#Appends the labels from the Value List to the given URL</li>
            <li>#Script Parameters </li>
            <li>#----------------------</li>
            <li>#1. WebAddress - The URL to which data parameters have to be appended</li>
            <li>#2. LabelListName - The Value List which has to be used for labels</li>
            <li>#3. FileName - The FileName where Value List is present</li>
            <li>#4. delimiter - (Optional) The delimiter to be used in this script. </li>
            <li># This is an optional parameter. The default value used is the one 
              specified in global values when FusionCharts is initialized.</li>
            <li>#Return Value </li>
            <li>#----------------------</li>
            <li>#Returns the new web address with the labels</li>
            <li>#appended to the given web address</li>
            <li>Set Variable [ $parameters; Value:Get(ScriptParameter) ]</li>
            <li>Set Variable [ $WebAddress; Value:GetValue($parameters;1) ]</li>
            <li>Set Variable [ $LabelListName; Value:GetValue($parameters;2) ]</li>
            <li>Set Variable [ $FileName; Value:GetValue($parameters;3) ]</li>
            <li>Set Variable [ $delimiter; Value:GetValue($parameters;4) ]</li>
            <li>Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) 
              ]</li>
            <li>Set Variable [ $labels; Value:Substitute(ValueListItems ( $FileName; 
              $LabelListName );"&para;";$delimiter) ]</li>
            <li>Perform Script [ &ldquo;AppendLabelsToURL&rdquo;; Parameter: $WebAddress 
              &amp; "&para;" &amp; $labels ]</li>
            <li>Set Variable [ $NewWebAddress; Value:Get(ScriptResult) ]</li>
            <li>Exit Script [ Result: $NewWebAddress ]</li>
          </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Scripts used in this script</td>
          <td valign="top" class="text"><ul>
              <li><a href="#AppendLabelsToURL">AppendLabelsToURL</a></li>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Pre-requisites for this script</td>
          <td valign="top" class="text">WebAddress parameter already has first set of parameters in the QueryString 
            starting with ?. </td>
        </tr>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="100%" class="tableAlternate" cellpadding="5" cellspacing="1">
      <tbody>
        <tr class="tableAlternateHeader textBold">
          <td width="32%" valign="top">Script Name</td>
          <td width="68%" valign="top"><a name="BuildAndAppendSSDataParams_FromRepetitions"/><span class="codeInline">BuildAndAppendSSDataParams 
            - FromRepetitions</span></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Usage</td>
          <td valign="top" class="text"><p>Can be Imported/Copy-Pasted.</p>
            <p>Preferred Usage: Import</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Category</td>
          <td valign="top" class="text">FusionCharts Data Parameters Helper Scripts</td>
        </tr>
        <tr >
          <td valign="top" class="textBold">Script Parameters</td>
          <td valign="top" class="text"><ol>
              <li> WebAddress - The URL to which data parameters have to be appended</li>
            <li>LabelFieldName - The field which has to be used for labels</li>
            <li>DataFieldName - The name of the field which has to be used for value</li>
            <li> NumberOfRepetitions - The number of repetitions of the field</li>
            <li> delimiter - (Optional) The delimiter to be used in this script. This 
              is an optional parameter. The default value used is the one specified 
              in global values when FusionCharts is initialized.</li>
          </ol></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Description</td>
          <td valign="top" class="text"><p>Constructs and appends the data parameter by getting the values in the 
            repetition field</p></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Result</td>
          <td valign="top" class="text"><p>Returns the new web address with the data parameters appended to the 
            given web address</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Run script with full access privileges</td>
          <td valign="top" class="text">Off</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Include In Menu</td>
          <td valign="top" class="text">No</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Layouts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Scripts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr class="tableAlternateHeader textBold">
          <td colSpan="2" valign="top">Script Definition</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Steps</td>
          <td valign="top" class="codeInline"><ul>
              <li>#Author InfoSoft Global(P) Ltd.</li>
            <li>#About the Script</li>
            <li>#----------------------</li>
            <li>#Constructs and appends the data parameter</li>
            <li>#by getting the values in the repetition field</li>
            <li>#Script Parameters </li>
            <li>#----------------------</li>
            <li>#1. WebAddress - The URL to which data parameters have to be appended</li>
            <li>#2. LabelFieldName - The field which has to be used for labels</li>
            <li>#3. DataFieldName - The name of the field which has to be used for 
              value</li>
            <li>#4. NumberOfRepetitions - The number of repetitions of the field</li>
            <li>#5. delimiter - (Optional) The delimiter to be used in this script. </li>
            <li># This is an optional parameter. The default value used is the one 
              specified in global values when FusionCharts is initialized.</li>
            <li>#Return Value </li>
            <li>#----------------------</li>
            <li>#Returns the new web address with the data parameters </li>
            <li>#appended to the given web address</li>
            <li>Set Variable [ $parameters; Value:Get(ScriptParameter) ]</li>
            <li>Set Variable [ $WebAddress; Value:GetValue($parameters;1) ]</li>
            <li>Set Variable [ $LabelFieldName; Value:GetValue($parameters;2) ]</li>
            <li>Set Variable [ $DataFieldName; Value:GetValue($parameters;3) ]</li>
            <li>Set Variable [ $NumberOfRepetitions; Value:GetAsNumber(GetValue($parameters;4)) 
              ]</li>
            <li>Set Variable [ $delimiter; Value:GetValue($parameters;5) ]</li>
            <li>Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) 
              ]</li>
            <li>#Initialize values</li>
            <li>Set Variable [ $LoopCounter; Value:1 ]</li>
            <li>Set Variable [ $data; Value:"" ]</li>
            <li>Loop</li>
            <li>Exit Loop If [ $LoopCounter &gt; $NumberOfRepetitions ]</li>
            <li>Set Variable [ $labels; Value:$labels &amp; If($LoopCounter &ne; 1;$delimiter;"") 
              &amp; GetField($LabelFieldName) ]</li>
            <li>Set Variable [ $data; Value:$data &amp; If($LoopCounter &ne; 1;$delimiter;"") 
              &amp; GetRepetition ( Evaluate(""&amp;$DataFieldName); $LoopCounter 
              ) ]</li>
            <li>Set Variable [ $LoopCounter; Value:$LoopCounter + 1 ]</li>
            <li>End Loop</li>
            <li>#Append the labels and data by performing script from FusionCharts 
              Library</li>
            <li>Perform Script [ &ldquo;AppendSSLabelsAndDataToURL&rdquo;; Parameter: 
              $WebAddress &amp; "&para;" &amp; $labels &amp; "&para;" &amp;$data ]</li>
            <li>Set Variable [ $NewWebAddress; Value:Get(ScriptResult) ]</li>
            <li>Exit Script [ Result: $NewWebAddress ]</li>
          </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Scripts used in this script</td>
          <td valign="top" class="text"><ul>
              <li><a href="#AppendSSLabelsAndDataToURL">AppendSSLabelsAndDataToURL</a></li>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Pre-requisites for this script</td>
          <td valign="top" class="text">WebAddress parameter already has first set of parameters in the QueryString 
            starting with ?. </td>
        </tr>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="100%" cellpadding="5" cellspacing="1" class="tableAlternate">
      <tbody>
        <tr class="tableAlternateHeader textBold">
          <td width="32%" valign="top">Script Name</td>
          <td width="68%" valign="top"><a name="BuildAndAppendSSDataParams_BySummingValuesInLayout"/><span class="codeInline">BuildAndAppendSSDataParams 
            - BySummingValuesInLayout</span></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Usage</td>
          <td valign="top" class="text"><p>Can be Imported/Copy-Pasted.</p>
            <p>Preferred Usage: Import</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Category</td>
          <td valign="top" class="text">FusionCharts Data Parameters Helper Scripts</td>
        </tr>
        <tr >
          <td valign="top" class="textBold">Script Parameters</td>
          <td valign="top" class="text"><ol>
              <li> WebAddress - The URL to which data parameters have to be appended</li>
            <li>LabelFieldName - The field which has to be used for labels</li>
            <li>SumByFieldName - The name of the field which has to be used for grouping 
              data</li>
            <li> DataFieldName - The name of the field which has to be used for value</li>
            <li> delimiter - (Optional) The delimiter to be used in this script. This 
              is an optional parameter. The default value used is the one specified 
              in global values when FusionCharts is initialized.</li>
          </ol></td>
        </tr>
        <tr class="tableAlternateDark">
          <td height="33" valign="top" class="textBold">Description</td>
          <td height="33" valign="top" class="text"><p>Constructs the data parameter by summing the values by grouping data 
            based on SumByFieldName parameter and appends it to the given web address</p></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Result</td>
          <td valign="top" class="text"><p>Returns the new web address with the data parameters appended to the 
            given web address</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Run script with full access privileges</td>
          <td valign="top" class="text">Off</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Include In Menu</td>
          <td valign="top" class="text">No</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Layouts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Scripts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr class="tableAlternateHeader textBold">
          <td colSpan="2" valign="top">Script Definition</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Steps</td>
          <td valign="top" class="codeInline"><ul>
              <li>#Author InfoSoft Global(P) Ltd.</li>
            <li>#About the Script</li>
            <li>#----------------------</li>
            <li>#Constructs the data parameter</li>
            <li>#by summing the values by grouping data based on SumByFieldName parameter</li>
            <li>#Script Parameters </li>
            <li>#----------------------</li>
            <li>#1. WebAddress - The URL to which data parameters have to be appended</li>
            <li>#2. LabelFieldName - The field which has to be used for labels</li>
            <li>#3. SumByFieldName - The name of the field which has to be used for 
              grouping data</li>
            <li>#4. DataFieldName - The name of the field which has to be used for 
              value</li>
            <li>#5. delimiter - (Optional) The delimiter to be used in this script. </li>
            <li># This is an optional parameter. The default value used is the one 
              specified in global values when FusionCharts is initialized.</li>
            <li>#Return Value </li>
            <li>#----------------------</li>
            <li>#Returns the new web address with the data parameters </li>
            <li>#appended to the given web address</li>
            <li>Set Variable [ $parameters; Value:Get(ScriptParameter) ]</li>
            <li>Set Variable [ $WebAddress; Value:GetValue($parameters;1) ]</li>
            <li>Set Variable [ $LabelFieldName; Value:GetValue($parameters;2) ]</li>
            <li>Set Variable [ $SumByFieldName; Value:GetValue($parameters;3) ]</li>
            <li>Set Variable [ $DataFieldName; Value:GetValue($parameters;4) ]</li>
            <li>Set Variable [ $delimiter; Value:GetValue($parameters;5) ]</li>
            <li>Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) 
              ]</li>
            <li>#Initialize values</li>
            <li>Set Variable [ $TotalRows; Value:Get(FoundCount) ]</li>
            <li>Set Variable [ $LoopCounter; Value:1 ]</li>
            <li>Set Variable [ $previousTotalValue; Value:0 ]</li>
            <li>Set Variable [ $PreviousSumByFieldValue; Value:"" ]</li>
            <li>Set Variable [ $appendDelimiter; Value:False ]</li>
            <li>#Loop through the records to calculate the total values</li>
            <li>Loop</li>
            <li>Exit Loop If [ $LoopCounter &gt; $TotalRows ]</li>
            <li>Go to Record/Request/Page [ $LoopCounter ] [ No dialog ]</li>
            <li>#Get the field value of $SumByFieldName by which the data has to be 
              grouped and summed up.</li>
            <li>Set Variable [ $SumByFieldValue; Value:GetField($SumByFieldName) ]</li>
            <li>#Get the label for this record</li>
            <li>Set Variable [ $LabelValue; Value:GetField($LabelFieldName) ]</li>
            <li>Set Variable [ $currentValue; Value:GetField($DataFieldName) ]</li>
            <li>#If sumByFieldValue for this record is not equal to that of previous 
              record,</li>
            <li>#Then append the previous totals to the data parameter</li>
            <li>If [ $SumByFieldValue &ne; $PreviousSumByFieldValue and $LoopCounter 
              &ne; 1 ]</li>
            <li>Set Variable [ $labels; Value:$labels &amp; If($appendDelimiter;$delimiter;"") 
              &amp; $previousLabel ]</li>
            <li>Set Variable [ $data; Value:$data &amp; If($appendDelimiter;$delimiter;"") 
              &amp; $previousTotalValue ]</li>
            <li>Set Variable [ $appendDelimiter; Value:True ]</li>
            <li>Set Variable [ $previousTotalValue; Value:0 ]</li>
            <li>End If</li>
            <li>Set Variable [ $previousLabel; Value:$LabelValue ]</li>
            <li>Set Variable [ $previousTotalValue; Value:$previousTotalValue + $currentValue 
              ]</li>
            <li>#For last record</li>
            <li>If [ $LoopCounter=$TotalRows ]</li>
            <li>Set Variable [ $labels; Value:$labels &amp; If($appendDelimiter;$delimiter;"") 
              &amp; $previousLabel ]</li>
            <li>Set Variable [ $data; Value:$data &amp; If($appendDelimiter;$delimiter;"") 
              &amp; $previousTotalValue ]</li>
            <li>Set Variable [ $appendDelimiter; Value:True ]</li>
            <li>Set Variable [ $previousTotalValue; Value:0 ]</li>
            <li>End If</li>
            <li>Set Variable [ $currentValue; Value:0 ]</li>
            <li>Set Variable [ $LoopCounter; Value:$LoopCounter + 1 ]</li>
            <li>Set Variable [ $PreviousSumByFieldValue; Value:$SumByFieldValue ]</li>
            <li>End Loop</li>
            <li>#Escape the Labels for forward slash and percentage characters.</li>
            <li>#Perform script from library</li>
            <li>Perform Script [ &ldquo;EscapePercentAndForwardSlashCharacters&rdquo; 
              from file: &ldquo;FusionCharts Library&rdquo;; Parameter: $labels ]</li>
            <li>Set Variable [ $labels; Value:Get(ScriptResult) ]</li>
            <li>#Append the labels and data by performing a script from FusionCharts 
              Library</li>
            <li>Perform Script [ &ldquo;AppendSSLabelsAndDataToURL&rdquo; from file: 
              &ldquo;FusionCharts Library&rdquo;; Parameter: $WebAddress &amp; "&para;" 
              &amp; $labels &amp; "&para;" &amp; $data ]</li>
            <li>Set Variable [ $NewWebAddress; Value:Get(ScriptResult) ]</li>
            <li>#Return the new web address</li>
            <li>Exit Script [ Result: $NewWebAddress ]</li>
          </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Scripts used in this script</td>
          <td valign="top" class="text"><ul>
              <li> <a href="EscapePercentAndForwardSlashCharacters" target="_top">EscapePercentAndForwardSlashCharacters </a> </li>
            <li> <a href="AppendSSLabelsAndDataToURL" target="_top">AppendSSLabelsAndDataToURL </a> </li>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Pre-requisites for this script</td>
          <td valign="top" class="text"><p>WebAddress parameter already has first set of parameters in the QueryString 
              starting with ?. </p>
            <p>The data has to be sorted by SumByFieldName field.</p></td>
        </tr>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="100%" class="tableAlternate" cellpadding="5" cellspacing="1">
      <tbody>
        <tr class="tableAlternateHeader textBold">
          <td width="32%" valign="top">Script Name</td>
          <td width="68%" valign="top"><a name="BuildAndAppendSSDataParams_LoopThroughPortalRows"/><span class="codeInline">BuildAndAppendSSDataParams 
            - LoopThroughPortalRows</span></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Usage</td>
          <td valign="top" class="text"><p>Can be Imported/Copy-Pasted.</p>
            <p>Preferred Usage: Import</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Category</td>
          <td valign="top" class="text">FusionCharts Data Parameters Helper Scripts</td>
        </tr>
        <tr >
          <td valign="top" class="textBold">Script Parameters</td>
          <td valign="top" class="text"><ol>
              <li> WebAddress - The URL to which data parameters have to be appended</li>
            <li>LabelFieldName - The field which has to be used for labels</li>
            <li> DataFieldName - The name of the field which has to be used for value</li>
            <li> delimiter - (Optional) The delimiter to be used in this script. This 
              is an optional parameter. The default value used is the one specified 
              in global values when FusionCharts is initialized.</li>
          </ol></td>
        </tr>
        <tr class="tableAlternateDark">
          <td height="33" valign="top" class="textBold">Description</td>
          <td height="33" valign="top" class="text"><p>Constructs the data parameter by looping through the portal record by 
            record. Assumes that we are in the layout where the data is present in 
            portal and uses the values from Active portal.</p>
            <p>The data is gathered from the active portal in the current layout.</p></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Result</td>
          <td valign="top" class="text"><p>Returns the new web address with the data parameters appended to the 
            given web address</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Run script with full access privileges</td>
          <td valign="top" class="text">Off</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Include In Menu</td>
          <td valign="top" class="text">No</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Layouts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Scripts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr class="tableAlternateHeader textBold">
          <td colSpan="2" valign="top">Script Definition</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Steps</td>
          <td valign="top" class="codeInline"><ul>
              <li>#Author InfoSoft Global (P) Ltd.</li>
            <li>#About the Script</li>
            <li>#----------------------</li>
            <li>#This script constructs the data parameter</li>
            <li>#by looping through the portal record by record</li>
            <li>#Assumes that we are in the layout where the data is present in portal</li>
            <li>#and uses the values from Active portal</li>
            <li>#Script Parameters </li>
            <li>#----------------------</li>
            <li>#1. WebAddress - The URL to which data parameters have to be appended</li>
            <li>#2. LabelFieldName - The field which has to be used for labels</li>
            <li>#3. DataFieldName - The name of the field which has to be used for 
              value</li>
            <li>#4. delimiter - (Optional) The delimiter to be used in this script. </li>
            <li># This is an optional parameter. The default value used is the one 
              specified in global values when FusionCharts is initialized.</li>
            <li>#Return Value </li>
            <li>#----------------------</li>
            <li>#Returns the new web address with the data parameters </li>
            <li>#appended to the given web address</li>
            <li>Set Variable [ $parameters; Value:Get(ScriptParameter) ]</li>
            <li>Set Variable [ $WebAddress; Value:GetValue($parameters;1) ]</li>
            <li>Set Variable [ $LabelFieldName; Value:GetValue($parameters;2) ]</li>
            <li>Set Variable [ $DataFieldName; Value:GetValue($parameters;3) ]</li>
            <li>Set Variable [ $delimiter; Value:GetValue($parameters;4) ]</li>
            <li># Delimiter value to be used for this chart</li>
            <li>Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) 
              ]</li>
            <li># Initializing all variables that are being used in this script</li>
            <li>Set Variable [ $data; Value:"" ]</li>
            <li>Set Variable [ $labels; Value:"" ]</li>
            <li>Set Variable [ $recordCount; Value:1 ]</li>
            <li>Set Variable [ $OriginalSelectedRow; Value:Get(PortalRowNumber) ]</li>
            <li># Go to the last row in the portal</li>
            <li>Go to Portal Row [ Last ]</li>
            <li>#Get the total number of rows</li>
            <li>Set Variable [ $TotalRows; Value:Get(PortalRowNumber) ]</li>
            <li>Set Variable [ $appendDelimiter; Value:False ]</li>
            <li>#Loop through the records to create</li>
            <li>#the data parameters part of the FusionCharts Querystring</li>
            <li>Loop</li>
            <li>Exit Loop If [ $recordCount &gt; $TotalRows ]</li>
            <li>Go to Portal Row [ $recordCount ] [ No dialog ]</li>
            <li>#Labels to be displayed - in this case, </li>
            <li>#year names separated by $$delimiter</li>
            <li>Set Variable [ $labels; Value:$labels &amp; If($appendDelimiter;$delimiter;"") 
              &amp; GetField($LabelFieldName) ]</li>
            <li>#The data used to draw the chart - the Amount field value</li>
            <li>Set Variable [ $data; Value:$data &amp; If($appendDelimiter;$delimiter;"") 
              &amp; GetField($DataFieldName) ]</li>
            <li>Set Variable [ $appendDelimiter; Value:True ]</li>
            <li>Set Variable [ $recordCount; Value:$recordCount + 1 ]</li>
            <li>End Loop</li>
            <li>#Go to the portal row where the focus was</li>
            <li>Go to Portal Row [ $OriginalSelectedRow ] [ No dialog ]</li>
            <li>Perform Script [ &ldquo;AppendSSLabelsAndDataToURL&rdquo; from file: 
              &ldquo;FusionCharts Library&rdquo;; Parameter: $WebAddress &amp; "&para;" 
              &amp; $labels &amp;"&para;" &amp; $data ]</li>
            <li>Set Variable [ $NewWebAddress; Value:Get(ScriptResult) ]</li>
            <li>Exit Script [ Result: $NewWebAddress ]</li>
          </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Scripts used in this script</td>
          <td valign="top" class="text"><ul>
              <li> <a href="AppendSSLabelsAndDataToURL" target="_top">AppendSSLabelsAndDataToURL </a> </li>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Pre-requisites for this script</td>
          <td valign="top" class="text"><p>WebAddress parameter already has first set of parameters in the QueryString 
              starting with ?. </p>
            <p>We are in the layout where the portal is present and the portal with 
              the data is active.</p>
            </td>
        </tr>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="100%" class="tableAlternate" cellpadding="5" cellspacing="1">
      <tbody>
        <tr class="tableAlternateHeader textBold">
          <td width="32%" valign="top">Script Name</td>
          <td width="68%" valign="top"><a name="BuildAndAppendSSDataParams_LoopThroughPortalInGroups"/><span class="codeInline">BuildAndAppendSSDataParams 
            - LoopThroughPortalInGroups</span></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Usage</td>
          <td valign="top" class="text"><p>Can be Imported/Copy-Pasted.</p>
            <p>Preferred Usage: Import</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Category</td>
          <td valign="top" class="text">FusionCharts Data Parameters Helper Scripts</td>
        </tr>
        <tr >
          <td valign="top" class="textBold">Script Parameters</td>
          <td valign="top" class="text"><ol>
              <li> WebAddress - The URL to which data parameters have to be appended</li>
            <li>LabelFieldName - The field which has to be used for labels</li>
            <li>DataFieldName - The name of the field which has to be used for value</li>
            <li>GroupByFieldName - The name of the field by which the data is grouped</li>
            <li> GroupByCountField - The name of the summary field which gives the 
              count</li>
            <li> delimiter - (Optional) The delimiter to be used in this script. This 
              is an optional parameter. The default value used is the one specified 
              in global values when FusionCharts is initialized.</li>
          </ol></td>
        </tr>
        <tr class="tableAlternateDark">
          <td height="77" valign="top" class="textBold">Description</td>
          <td height="77" valign="top" class="text"><p> Constructs the data parameter by summing the value, after grouping by 
            the SumByFieldName.</p>
            <p>The data is gathered from the active portal in the current layout.</p></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Result</td>
          <td valign="top" class="text"><p>Returns the new web address with the data parameters appended to the 
            given web address</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Run script with full access privileges</td>
          <td valign="top" class="text">Off</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Include In Menu</td>
          <td valign="top" class="text">No</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Layouts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Scripts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr class="tableAlternateHeader textBold">
          <td colSpan="2" valign="top">Script Definition</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Steps</td>
          <td valign="top" class="codeInline"><ul>
              <li>#Author InfoSoft Global (P) Ltd.</li>
            <li>#About the Script</li>
            <li>#----------------------</li>
            <li>#This script constructs the data parameter</li>
            <li>#by summing the value after grouping by the SumByFieldName</li>
            <li>#Assumes that we are in the layout where the data is present in portal</li>
            <li>#and uses the values from Active portal</li>
            <li>#Script Parameters </li>
            <li>#----------------------</li>
            <li>#1. WebAddress - The URL to which data parameters have to be appended</li>
            <li>#2. LabelFieldName - The field which has to be used for labels</li>
            <li>#3. DataFieldName - The name of the field which has to be used for 
              value</li>
            <li>#4. GroupByFieldName - The name of the field by which the data is 
              grouped</li>
            <li>#5. GroupByCountField - The name of the summary field which gives 
              the count</li>
            <li>#6. delimiter - (Optional) The delimiter to be used in this script. </li>
            <li># This is an optional parameter. The default value used is the one 
              specified in global values when FusionCharts is initialized.</li>
            <li>#Return Value </li>
            <li>#----------------------</li>
            <li>#Returns the new web address with the data parameters </li>
            <li>#appended to the given web address</li>
            <li>Set Variable [ $parameters; Value:Get(ScriptParameter) ]</li>
            <li>Set Variable [ $WebAddress; Value:GetValue($parameters;1) ]</li>
            <li>Set Variable [ $LabelFieldName; Value:GetValue($parameters;2) ]</li>
            <li>Set Variable [ $DataFieldName; Value:GetValue($parameters;3) ]</li>
            <li>Set Variable [ $GroupByFieldName; Value:GetValue($parameters;4) ]</li>
            <li>Set Variable [ $GroupByCountField; Value:GetValue($parameters;5) ]</li>
            <li>Set Variable [ $delimiter; Value:GetValue($parameters;6) ]</li>
            <li># Delimiter value to be used for this chart</li>
            <li>Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) 
              ]</li>
            <li># Initializing all variables that are being used in this script</li>
            <li>Set Variable [ $data; Value:"" ]</li>
            <li>Set Variable [ $labels; Value:"" ]</li>
            <li>Set Variable [ $loopCounter; Value:0 ]</li>
            <li>Set Variable [ $OriginalSelectedRow; Value:Get(PortalRowNumber) ]</li>
            <li># Go to the last row in the portal</li>
            <li>Go to Portal Row [ Last ]</li>
            <li>#Get the total number of rows</li>
            <li>Set Variable [ $totalRows; Value:Get(PortalRowNumber) ]</li>
            <li>Set Variable [ $recordCount; Value:1 ]</li>
            <li>Set Error Capture [ On ]</li>
            <li># Go to the first row in the portal</li>
            <li>Go to Portal Row [ Select; First ]</li>
            <li># Loop through each row in the portal </li>
            <li>Loop</li>
            <li>Exit Loop If [ $recordCount &gt; $totalRows ]</li>
            <li>Set Variable [ $loopCounter; Value:$loopCounter+1 ]</li>
            <li>If [ $loopCounter=1 ]</li>
            <li>Set Variable [ $delim; Value:"" ]</li>
            <li>Else</li>
            <li>Set Variable [ $delim; Value:$delimiter ]</li>
            <li>End If</li>
            <li># Get the value for label</li>
            <li>Set Variable [ $labels; Value:$labels &amp; $delim &amp; GetField($LabelFieldName) 
              ]</li>
            <li># Get the value present in $DataFieldName using GetField</li>
            <li>#This field will usually be the Summary field </li>
            <li>#containing the sum when grouped by the field $GroupByFieldName</li>
            <li>Set Variable [ $data; Value:$data &amp; $delim &amp; GetField($DataFieldName) 
              ]</li>
            <li>Set Variable [ $recordCount; Value:$recordCount + GetSummary ( GetField($GroupByCountField);GetField($GroupByFieldName)) 
              ]</li>
            <li># Go to the next portal row - move to next group in the portal</li>
            <li>Go to Portal Row [ $recordCount ] [ Select; No dialog ]</li>
            <li>End Loop</li>
            <li>#Go to the row which was initially selected by the user</li>
            <li>Go to Portal Row [ $OriginalSelectedRow ] [ No dialog ]</li>
            <li>#Perform script from FusionCharts library to append the labels and 
              data to the URL</li>
            <li>Perform Script [ &ldquo;AppendSSLabelsAndDataToURL&rdquo; from file: 
              &ldquo;FusionCharts Library&rdquo;; Parameter: $WebAddress &amp;"&para;" 
              &amp; $labels &amp; "&para;" &amp; $data ]</li>
            <li>Set Variable [ $NewWebAddress; Value:Get(ScriptResult) ]</li>
            <li>#Return the new web address</li>
            <li>Exit Script [ Result: $NewWebAddress ]</li>
          </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Scripts used in this script</td>
          <td valign="top" class="text"><ul>
              <li> <a href="AppendSSLabelsAndDataToURL" target="_top">AppendSSLabelsAndDataToURL </a> </li>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Pre-requisites for this script</td>
          <td valign="top" class="text"><p>WebAddress parameter already has first set of parameters in the QueryString 
              starting with ?. </p>
            <p>We are in the layout where the portal is present and the portal with 
              the data is active.</p>
            <p>Count field(GroupByCountField) is defined for the field (GroupByFieldName) 
              by which data is sorted. Count field is a summary field defined as the 
              count of a unique field, summary restarted for each group when sorted 
              by a GroupByFieldName field. The data has to be sorted by this GroupByFieldName 
              field.</p>
            </td>
        </tr>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="100%" class="tableAlternate" cellpadding="5" cellspacing="1">
      <tbody>
        <tr class="tableAlternateHeader textBold">
          <td width="32%" valign="top">Script Name</td>
          <td width="68%" valign="top"><a name="BuildAndAppendSSDataParams_UsingGetNthRecord"/><span class="codeInline">BuildAndAppendSSDataParams-UsingGetNthRecord</span></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Usage</td>
          <td valign="top" class="text"><p>Can be Imported/Copy-Pasted.</p>
            <p>Preferred Usage: Import</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Category</td>
          <td valign="top" class="text">FusionCharts Data Parameters Helper Scripts</td>
        </tr>
        <tr >
          <td valign="top" class="textBold">Script Parameters</td>
          <td valign="top" class="text"><ol>
              <li> WebAddress - The URL to which data parameters have to be appended</li>
            <li>LabelFieldName - The field which has to be used for labels</li>
            <li>DataFieldName - The name of the field which has to be used for value</li>
            <li> delimiter - (Optional) The delimiter to be used in this script. This 
              is an optional parameter. The default value used is the one specified 
              in global values when FusionCharts is initialized.</li>
          </ol></td>
        </tr>
        <tr class="tableAlternateDark">
          <td height="77" valign="top" class="textBold">Description</td>
          <td height="77" valign="top" class="text"><p>Constructs the data parameter by using the DataFieldName field for value.</p>
              <p>Assumes that we are in the layout where the data is present and uses 
            GetNthRecord for getting the values</p></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Result</td>
          <td valign="top" class="text"><p>Returns the new web address with the data parameters appended to the 
            given web address</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Run script with full access privileges</td>
          <td valign="top" class="text">Off</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Include In Menu</td>
          <td valign="top" class="text">No</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Layouts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Scripts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr class="tableAlternateHeader textBold">
          <td colSpan="2" valign="top">Script Definition</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Steps</td>
          <td valign="top" class="codeInline"><ul>
              <li>#Author InfoSoft Global (P) Ltd.</li>
            <li>#About the Script</li>
            <li>#----------------------</li>
            <li>#This script constructs the data parameter</li>
            <li>#by using the DataFieldName field for value</li>
            <li>#Assumes that we are in the layout where the data is present</li>
            <li>#and uses GetNthRecord for getting the values</li>
            <li>#Script Parameters </li>
            <li>#----------------------</li>
            <li>#1. WebAddress - The URL to which data parameters have to be appended</li>
            <li>#2. LabelFieldName - The field which has to be used for labels</li>
            <li>#3. DataFieldName - The name of the field which has to be used for 
              value</li>
            <li>#4. delimiter - (Optional) The delimiter to be used in this script. </li>
            <li># This is an optional parameter. The default value used is the one 
              specified in global values when FusionCharts is initialized.</li>
            <li>#Return Value </li>
            <li>#----------------------</li>
            <li>#Returns the new web address with the data parameters </li>
            <li>#appended to the given web address</li>
            <li>Set Variable [ $parameters; Value:Get(ScriptParameter) ]</li>
            <li>Set Variable [ $WebAddress; Value:GetValue($parameters;1) ]</li>
            <li>Set Variable [ $LabelFieldName; Value:GetValue($parameters;2) ]</li>
            <li>Set Variable [ $DataFieldName; Value:GetValue($parameters;3) ]</li>
            <li>Set Variable [ $delimiter; Value:GetValue($parameters;4) ]</li>
            <li># Delimiter value to be used for this chart</li>
            <li>Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) 
              ]</li>
            <li># Initializing all variables that are being used in this script</li>
            <li>Set Variable [ $values; Value:"" ]</li>
            <li>Set Variable [ $showLabels; Value:"" ]</li>
            <li>Set Variable [ $labels; Value:"" ]</li>
            <li>Set Variable [ $loopCounter; Value:0 ]</li>
            <li>Set Variable [ $recordCount; Value:1 ]</li>
            <li>#Get the total number of rows</li>
            <li>Set Variable [ $totalRows; Value:Get(FoundCount) ]</li>
            <li>Set Error Capture [ On ]</li>
            <li># Loop through the records</li>
            <li>Loop</li>
            <li>Exit Loop If [ $recordCount &gt; $totalRows ]</li>
            <li>Set Variable [ $currentLabel; Value:GetNthRecord (GetField($LabelFieldName); 
              $recordCount) ]</li>
            <li>Set Variable [ $currentValue; Value:GetNthRecord (GetField($DataFieldName);$recordCount) 
              ]</li>
            <li>Set Variable [ $loopCounter; Value:$loopCounter+1 ]</li>
            <li>If [ $loopCounter=1 ]</li>
            <li>Set Variable [ $delim; Value:"" ]</li>
            <li>Else</li>
            <li>Set Variable [ $delim; Value:$delimiter ]</li>
            <li>End If</li>
            <li># The label used for display in the chart</li>
            <li>Set Variable [ $labels; Value:$labels &amp; $delim &amp; $currentLabel 
              ]</li>
            <li># The value used in the chart (Summary field containing the total 
              for this group)</li>
            <li>Set Variable [ $values; Value:$values &amp; $delim &amp; $currentValue 
              ]</li>
            <li># Loop through the records one by one</li>
            <li>Set Variable [ $recordCount; Value:$recordCount +1 ]</li>
            <li>End Loop</li>
            <li>#Perform script from FusionCharts library to append the labels and 
              data to the URL</li>
            <li>Perform Script [ &ldquo;AppendSSLabelsAndDataToURL&rdquo; from file: 
              &ldquo;FusionCharts Library&rdquo;; Parameter: $WebAddress &amp;"&para;" 
              &amp; $labels &amp; "&para;" &amp; $values ]</li>
            <li>Set Variable [ $NewWebAddress; Value:Get(ScriptResult) ]</li>
            <li>#Return the new web address</li>
            <li>Exit Script [ Result: $NewWebAddress ]</li>
          </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Scripts used in this script</td>
          <td valign="top" class="text"><ul>
              <li> <a href="AppendSSLabelsAndDataToURL" target="_top">AppendSSLabelsAndDataToURL </a> </li>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Pre-requisites for this script</td>
          <td valign="top" class="text"><p>WebAddress parameter already has first set of parameters in the QueryString 
              starting with ?. </p>
            <p>We are in the layout where the data is present.</p>
            </td>
        </tr>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="100%" cellpadding="5" cellspacing="1" class="tableAlternate">
      <tbody>
        <tr class="tableAlternateHeader textBold">
          <td width="32%" valign="top">Script Name</td>
          <td width="68%" valign="top"><a name="BuildAndAppendSSDataParams_UsingGetNthRecord_UseLabelList"/><span class="codeInline">BuildAndAppendSSDataParams-UsingGetNthRecord</span> 
            -UseLabelList</td>
        </tr>
        <tr class="tableAlternate">
          <td valign="top" class="textBold">Script Usage</td>
          <td valign="top" class="text"><p>Can be Imported/Copy-Pasted.</p>
            <p>Preferred Usage: Import</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Category</td>
          <td valign="top" class="text">FusionCharts Data Parameters Helper Scripts</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Parameters</td>
          <td valign="top" class="text"><ol>
              <li> WebAddress - The URL to which data parameters have to be appended</li>
            <li> LabelListName - The Value List which has to be used for labels</li>
            <li>DataFieldName - The name of the field which has to be used for value</li>
            <li> delimiter - (Optional) The delimiter to be used in this script. This 
              is an optional parameter. The default value used is the one specified 
              in global values when FusionCharts is initialized.</li>
          </ol></td>
        </tr>
        <tr class="tableAlternateDark">
          <td height="77" valign="top" class="textBold">Description</td>
          <td height="77" valign="top" class="text"><p>Constructs the data parameter from the DataFieldName field.</p>
              <p>Assumes that we are in the layout where the data is present and uses 
              GetNthRecord for getting the values. Uses <span class="codeInline">Value 
            List </span>to get the labels.</p></td>
        </tr>
        <tr class="tableAlternate">
          <td valign="top" class="textBold">Result</td>
          <td valign="top" class="text"><p>Returns the new web address with the data parameters appended to the 
            given web address</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Run script with full access privileges</td>
          <td valign="top" class="text">Off</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Include In Menu</td>
          <td valign="top" class="text">No</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Layouts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Scripts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr class="tableAlternateHeader textBold">
          <td colSpan="2" valign="top">Script Definition</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Steps</td>
          <td valign="top" class="codeInline"><ul>
              <li>#Author InfoSoft Global (P) Ltd.</li>
            <li>#About the Script</li>
            <li>#----------------------</li>
            <li>#This script constructs the data parameter</li>
            <li>#by using the DataFieldName field for value</li>
            <li>#Assumes that we are in the layout where the data is present</li>
            <li>#and uses GetNthRecord for getting the values</li>
            <li>#Script Parameters </li>
            <li>#----------------------</li>
            <li>#1. WebAddress - The URL to which data parameters have to be appended</li>
            <li>#2. LabelListName - The Value List which has to be used for labels</li>
            <li>#3. DataFieldName - The name of the field which has to be used for 
              value</li>
            <li>#4. delimiter - (Optional) The delimiter to be used in this script. </li>
            <li># This is an optional parameter. The default value used is the one 
              specified in global values when FusionCharts is initialized.</li>
            <li>#Return Value </li>
            <li>#----------------------</li>
            <li>#Returns the new web address with the data parameters </li>
            <li>#appended to the given web address</li>
            <li>Set Variable [ $parameters; Value:Get(ScriptParameter) ]</li>
            <li>Set Variable [ $WebAddress; Value:GetValue($parameters;1) ]</li>
            <li>Set Variable [ $LabelListName; Value:GetValue($parameters;2) ]</li>
            <li>Set Variable [ $DataFieldName; Value:GetValue($parameters;3) ]</li>
            <li>Set Variable [ $delimiter; Value:GetValue($parameters;4) ]</li>
            <li># Delimiter value to be used for this chart</li>
            <li>Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) 
              ]</li>
            <li># Initializing all variables that are being used in this script</li>
            <li>Set Variable [ $values; Value:"" ]</li>
            <li>Set Variable [ $showLabels; Value:"" ]</li>
            <li>Set Variable [ $loopCounter; Value:0 ]</li>
            <li>Set Variable [ $recordCount; Value:1 ]</li>
            <li>#Get the total number of rows</li>
            <li>Set Variable [ $totalRows; Value:Get(FoundCount) ]</li>
            <li>Set Variable [ $labels; Value:Substitute(ValueListItems(Get(FileName);$LabelListName);"&para;";$$delimiter) 
              ]</li>
            <li>Set Error Capture [ On ]</li>
            <li># Loop through the records</li>
            <li>Loop</li>
            <li>Exit Loop If [ $recordCount &gt; $totalRows ]</li>
            <li>Set Variable [ $currentValue; Value:GetNthRecord (GetField($DataFieldName);$recordCount) 
              ]</li>
            <li>Set Variable [ $loopCounter; Value:$loopCounter+1 ]</li>
            <li>If [ $loopCounter=1 ]</li>
            <li>Set Variable [ $delim; Value:"" ]</li>
            <li>Else</li>
            <li>Set Variable [ $delim; Value:$delimiter ]</li>
            <li>End If</li>
            <li># The value used in the chart (Summary field containing the total 
              for this group)</li>
            <li>Set Variable [ $values; Value:$values &amp; $delim &amp; $currentValue 
              ]</li>
            <li># Loop through the records one by one</li>
            <li>Set Variable [ $recordCount; Value:$recordCount +1 ]</li>
            <li>End Loop</li>
            <li>#Perform script from FusionCharts library to append the labels and 
              data to the URL</li>
            <li>Perform Script [ &ldquo;AppendSSLabelsAndDataToURL&rdquo; from file: 
              &ldquo;FusionCharts Library&rdquo;; Parameter: $WebAddress &amp;"&para;" 
              &amp; $labels &amp; "&para;" &amp; $values ]</li>
            <li>Set Variable [ $NewWebAddress; Value:Get(ScriptResult) ]</li>
            <li>#Return the new web address</li>
            <li>Exit Script [ Result: $NewWebAddress ]</li>
          </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Scripts used in this script</td>
          <td valign="top" class="text"><ul>
              <li> <a href="AppendSSLabelsAndDataToURL" target="_top">AppendSSLabelsAndDataToURL </a> </li>
          </ul></td>
        </tr>
        <tr class="tableAlternate">
          <td valign="top" class="textBold">Pre-requisites for this script</td>
          <td valign="top" class="text"><p>WebAddress parameter already has first set of parameters in the QueryString 
              starting with ?. </p>
            <p>We are in the layout where the data is present.</p>
            <p>LabelList and the file in which it is present has to be accessible from 
            external fp7 file.</p></td>
        </tr>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="100%" class="tableAlternate" cellpadding="5" cellspacing="1">
      <tbody>
        <tr class="tableAlternateHeader textBold">
          <td width="32%" valign="top">Script Name</td>
          <td width="68%" valign="top"><a name="BuildAndAppendSSDataParams_LoopInGroups_UsingGetNthRecord"/><span class="codeInline">BuildAndAppendSSDataParams-LoopInGroups-UsingGetNthRecord</span></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Usage</td>
          <td valign="top" class="text"><p>Can be Imported/Copy-Pasted.</p>
            <p>Preferred Usage: Import</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Category</td>
          <td valign="top" class="text">FusionCharts Data Parameters Helper Scripts</td>
        </tr>
        <tr >
          <td valign="top" class="textBold">Script Parameters</td>
          <td valign="top" class="text"><ol>
              <li> WebAddress - The URL to which data parameters have to be appended</li>
            <li> LabelFieldName - The field which has to be used for labels</li>
            <li>DataFieldName - The name of the field which has to be used for value</li>
            <li>GroupByCountField - The name of the count field for the groups</li>
            <li> recordCount - The record number to start from</li>
            <li> delimiter - (Optional) The delimiter to be used in this script. This 
              is an optional parameter. The default value used is the one specified 
              in global values when FusionCharts is initialized.</li>
          </ol></td>
        </tr>
        <tr class="tableAlternateDark">
          <td height="77" valign="top" class="textBold">Description</td>
          <td height="77" valign="top" class="text"><p>Constructs the data parameter by using the DataFieldName field for value. 
                Moves through records in groups instead of one after the other</p>
              <p>Assumes that we are in the layout where the data is present and uses 
            GetNthRecord for getting the values. </p></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Result</td>
          <td valign="top" class="text"><p>Returns the new web address with the data parameters appended to the 
            given web address</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Run script with full access privileges</td>
          <td valign="top" class="text">Off</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Include In Menu</td>
          <td valign="top" class="text">No</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Layouts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Scripts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr class="tableAlternateHeader textBold">
          <td colSpan="2" valign="top">Script Definition</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Steps</td>
          <td valign="top" class="codeInline"><ul>
              <li>#Author InfoSoft Global (P) Ltd.</li>
            <li>#About the Script</li>
            <li>#----------------------</li>
            <li>#This script constructs the data parameter</li>
            <li>#by using the DataFieldName field for value</li>
            <li>#moves through records in groups instead of one after the other</li>
            <li>#Assumes that we are in the layout where the data is present</li>
            <li>#and uses GetNthRecord for getting the values</li>
            <li>#Script Parameters </li>
            <li>#----------------------</li>
            <li>#1. WebAddress - The URL to which data parameters have to be appended</li>
            <li>#2. LabelFieldName - The field which has to be used for labels</li>
            <li>#3. DataFieldName - The name of the field which has to be used for 
              value</li>
            <li>#4. GroupByCountField - The name of the count field for the groups</li>
            <li>#5. recordCount - The record number to start from</li>
            <li>#6. delimiter - (Optional) The delimiter to be used in this script. </li>
            <li># This is an optional parameter. The default value used is the one 
              specified in global values when FusionCharts is initialized.</li>
            <li>#Return Value </li>
            <li>#----------------------</li>
            <li>#Returns the new web address with the data parameters </li>
            <li>#appended to the given web address</li>
            <li>Set Variable [ $parameters; Value:Get(ScriptParameter) ]</li>
            <li>Set Variable [ $WebAddress; Value:GetValue($parameters;1) ]</li>
            <li>Set Variable [ $LabelFieldName; Value:GetValue($parameters;2) ]</li>
            <li>Set Variable [ $DataFieldName; Value:GetValue($parameters;3) ]</li>
            <li>Set Variable [ $GroupByCountField; Value:GetValue($parameters;4) ]</li>
            <li>#Record number to start from</li>
            <li>Set Variable [ $recordCount; Value:GetAsNumber(GetValue ($parameters;5)) 
              ]</li>
            <li>Set Variable [ $delimiter; Value:GetValue($parameters;6) ]</li>
            <li># Delimiter value to be used for this chart</li>
            <li>Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) 
              ]</li>
            <li># Initializing all variables that are being used in this script</li>
            <li>Set Variable [ $values; Value:"" ]</li>
            <li>Set Variable [ $showLabels; Value:"" ]</li>
            <li>Set Variable [ $labels; Value:"" ]</li>
            <li>Set Variable [ $loopCounter; Value:0 ]</li>
            <li>#Get the total number of rows</li>
            <li>Set Variable [ $totalRows; Value:Get(FoundCount) ]</li>
            <li>Set Error Capture [ On ]</li>
            <li># Loop through the records</li>
            <li>Loop</li>
            <li>Exit Loop If [ $recordCount &gt; $totalRows ]</li>
            <li>Set Variable [ $currentLabel; Value:GetNthRecord (GetField($LabelFieldName); 
              $recordCount) ]</li>
            <li>Set Variable [ $currentValue; Value:GetNthRecord (GetField($DataFieldName);$recordCount) 
              ]</li>
            <li>#Get the total number of records in this group</li>
            <li>Set Variable [ $currentTotalForGroupCount; Value:GetNthRecord (GetField($GroupByCountField);$recordCount) 
              ]</li>
            <li>Set Variable [ $loopCounter; Value:$loopCounter+1 ]</li>
            <li>If [ $loopCounter=1 ]</li>
            <li>Set Variable [ $delim; Value:"" ]</li>
            <li>Else</li>
            <li>Set Variable [ $delim; Value:$delimiter ]</li>
            <li>End If</li>
            <li># The label used for display in the chart</li>
            <li>Set Variable [ $labels; Value:$labels &amp; $delim &amp; $currentLabel 
              ]</li>
            <li># The value used in the chart (Summary field containing the total 
              for this group)</li>
            <li>Set Variable [ $values; Value:$values &amp; $delim &amp; $currentValue 
              ]</li>
            <li># Loop through the records in chunks</li>
            <li># Move on to the next group so that we get unique values</li>
            <li>Set Variable [ $recordCount; Value:$recordCount +$currentTotalForGroupCount 
              ]</li>
            <li>End Loop</li>
            <li>#Perform script from FusionCharts library to append the labels and 
              data to the URL</li>
            <li>Perform Script [ &ldquo;AppendSSLabelsAndDataToURL&rdquo; from file: 
              &ldquo;FusionCharts Library&rdquo;; Parameter: $WebAddress &amp;"&para;" 
              &amp; $labels &amp; "&para;" &amp; $values ]</li>
            <li>Set Variable [ $NewWebAddress; Value:Get(ScriptResult) ]</li>
            <li>#Return the new web address</li>
            <li>Exit Script [ Result: $NewWebAddress ]</li>
          </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Scripts used in this script</td>
          <td valign="top" class="text"><ul>
              <li> <a href="AppendSSLabelsAndDataToURL" target="_top">AppendSSLabelsAndDataToURL </a> </li>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Pre-requisites for this script</td>
          <td valign="top" class="text"><p>WebAddress parameter already has first set of parameters in the QueryString 
              starting with ?. </p>
            <p>We are in the layout where the data is present. </p>
            <p>Count field is defined for the field by which data is sorted. Count field 
              is a summary field defined as the count of a unique field, summary restarted 
              for each group when sorted by a particular field. The data has to be sorted 
              by this particular field.</p>
            </td>
        </tr>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="100%" class="tableAlternate" cellpadding="5" cellspacing="1">
      <tbody>
        <tr class="tableAlternateHeader textBold">
          <td width="32%" valign="top">Script Name</td>
          <td width="68%" valign="top"><a name="BuildAndAppendMSDataParams_UsingGetNthRecord_UseLabelList"/><span class="codeInline">BuildAndAppendMSDataParams-UsingGetNthRecord-UseLabelList</span></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Usage</td>
          <td valign="top" class="text"><p>Can be Imported/Copy-Pasted.</p>
            <p>Preferred Usage: Import</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Category</td>
          <td valign="top" class="text">FusionCharts Data Parameters Helper Scripts</td>
        </tr>
        <tr >
          <td valign="top" class="textBold">Script Parameters</td>
          <td valign="top" class="text"><ol>
              <li> WebAddress - The URL to which data parameters have to be appended</li>
            <li> LabelFieldName - The field which has to be used for labels</li>
            <li>DataFieldName - The name of the field which has to be used for value</li>
            <li>GroupByCountField - The name of the count field for the groups</li>
            <li> recordCount - The record number to start from</li>
            <li> delimiter - (Optional) The delimiter to be used in this script. This 
              is an optional parameter. The default value used is the one specified 
              in global values when FusionCharts is initialized.</li>
          </ol></td>
        </tr>
        <tr class="tableAlternateDark">
          <td height="77" valign="top" class="textBold">Description</td>
          <td height="77" valign="top" class="text"><p>Constructs the data parameter for multi-series chart by using the DataFieldName 
                field for value and SeriesFieldName for seriesName. Moves through records 
                one after the other.</p>
              <p>Assumes that we are in the layout where the data is present and uses 
            GetNthRecord for getting the values. </p></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Result</td>
          <td valign="top" class="text"><p>Returns the new web address with the data parameters appended to the 
            given web address</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Run script with full access privileges</td>
          <td valign="top" class="text">Off</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Include In Menu</td>
          <td valign="top" class="text">No</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Layouts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Scripts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr class="tableAlternateHeader textBold">
          <td colSpan="2" valign="top">Script Definition</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Steps</td>
          <td valign="top" class="codeInline"><ul>
              <li>#Author InfoSoft Global (P) Ltd.</li>
            <li>#About the Script</li>
            <li>#----------------------</li>
            <li>#This script constructs the data parameter</li>
            <li>#for a multi-series chart</li>
            <li>#by going through each record, using SeriesFieldName value for seriesName</li>
            <li>#and DataFieldName for values to be shown on chart</li>
            <li>#Uses LabelListName Value List to construct the labels</li>
            <li>#Assumes that we are in the layout where the data is present</li>
            <li>#and uses GetNthRecord for getting the values</li>
            <li>#Script Parameters </li>
            <li>#----------------------</li>
            <li>#1. WebAddress - The URL to which data parameters have to be appended</li>
            <li>#2. LabelListName - The Value List which has to be used for labels</li>
            <li>#3. SeriesFieldName - The name of the field which has to be used as 
              name for Series</li>
            <li>#4. DataFieldName - The name of the field which has to be used for 
              value</li>
            <li>#5. delimiter - (Optional) The delimiter to be used in this script. </li>
            <li># This is an optional parameter. The default value used is the one 
              specified in global values when FusionCharts is initialized.</li>
            <li>#Return Value </li>
            <li>#----------------------</li>
            <li>#Returns the new web address with the data parameters </li>
            <li>#appended to the given web address</li>
            <li>Set Variable [ $parameters; Value:Get(ScriptParameter) ]</li>
            <li>Set Variable [ $WebAddress; Value:GetValue($parameters;1) ]</li>
            <li>Set Variable [ $LabelListName; Value:GetValue($parameters;2) ]</li>
            <li>Set Variable [ $SeriesFieldName; Value:GetValue($parameters;3) ]</li>
            <li>Set Variable [ $DataFieldName; Value:GetValue($parameters;4) ]</li>
            <li>Set Variable [ $delimiter; Value:GetValue($parameters;5) ]</li>
            <li># Delimiter value to be used for this chart</li>
            <li>Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) 
              ]</li>
            <li># The label used for display in the chart</li>
            <li>Set Variable [ $labels; Value: Substitute(ValueListItems (Get(FileName); 
              $LabelListName);"&para;";$delimiter) ]</li>
            <li># Initializing all variables that are being used in this script</li>
            <li>Set Variable [ $values; Value:"" ]</li>
            <li>Set Variable [ $data; Value:"" ]</li>
            <li>Set Variable [ $showLabels; Value:"" ]</li>
            <li>Set Variable [ $valueCounter; Value:0 ]</li>
            <li>Set Variable [ $recordCount; Value:1 ]</li>
            <li>#Get the total number of rows</li>
            <li>Set Variable [ $totalRows; Value:Get(FoundCount) ]</li>
            <li>Set Variable [ $appendDelimiter; Value:False ]</li>
            <li>Set Error Capture [ On ]</li>
            <li># Loop through the records</li>
            <li>Loop</li>
            <li>Exit Loop If [ $recordCount &gt; $totalRows ]</li>
            <li>Set Variable [ $currentValue; Value:GetNthRecord (GetField($DataFieldName);$recordCount) 
              ]</li>
            <li>Set Variable [ $currentSeriesName; Value:GetNthRecord (GetField($SeriesFieldName);$recordCount) 
              ]</li>
            <li>Set Variable [ $valueCounter; Value:$valueCounter+1 ]</li>
            <li>If [ $recordCount=1 ]</li>
            <li>Set Variable [ $previousSeriesName; Value:$currentSeriesName ]</li>
            <li>End If</li>
            <li>If [ $valueCounter &gt; 1 ]</li>
            <li>Set Variable [ $appendDelimiter; Value:True ]</li>
            <li>End If</li>
            <li>If [ $currentSeriesName &ne; $previousSeriesName ]</li>
            <li>Set Variable [ $data; Value:$data &amp; "&amp;data=[seriesName=" &amp;$previousSeriesName 
              &amp;"]" &amp;$values ]</li>
            <li>Set Variable [ $values; Value:"" ]</li>
            <li>Set Variable [ $appendDelimiter; Value:False ]</li>
            <li>Set Variable [ $valueCounter; Value:1 ]</li>
            <li>End If</li>
            <li>Set Variable [ $previousSeriesName; Value:$currentSeriesName ]</li>
            <li>Set Variable [ $values; Value:$values &amp; If($appendDelimiter;$delimiter;"") 
              &amp; $currentValue ]</li>
            <li>If [ $recordCount= $totalRows ]</li>
            <li>Set Variable [ $data; Value:$data &amp; "&amp;data=[seriesName=" &amp;$previousSeriesName 
              &amp;"]" &amp;$values ]</li>
            <li>End If</li>
            <li># Loop through the records one by one</li>
            <li>Set Variable [ $recordCount; Value:$recordCount +1 ]</li>
            <li>End Loop</li>
            <li>Set Variable [ $NewWebAddress; Value:$WebAddress &amp; "&amp;labels="&amp; 
              $labels &amp; $data ]</li>
            <li>#Return the new web address</li>
            <li>Exit Script [ Result: $NewWebAddress ]</li>
          </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Scripts used in this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Pre-requisites for this script</td>
          <td valign="top" class="text"><p>WebAddress parameter already has first set of parameters in the QueryString 
              starting with ?. </p>
            <p>We are in the layout where the data is present. The Value List identified 
              by LabelListName is present in the same fp7 as this script.</p>
            <p>Note that this script needs to be imported/copy-pasted as mentioned in 
              the <span class="codeInline">Script Usage</span>.</p>
            </td>
        </tr>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="100%" class="tableAlternate" cellpadding="5" cellspacing="1">
      <tbody>
        <tr class="tableAlternateHeader textBold">
          <td width="32%" valign="top">Script Name</td>
          <td width="68%" valign="top"><a name="BuildAndAppendMSDataParams_LoopThroughPortalInGroups"/><span class="codeInline">BuildAndAppendMSDataParams-LoopThroughPortalInGroups</span></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Usage</td>
          <td valign="top" class="text"><p>Can be Imported/Copy-Pasted.</p>
            <p>Preferred Usage: Import</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Category</td>
          <td valign="top" class="text">FusionCharts Data Parameters Helper Scripts</td>
        </tr>
        <tr >
          <td valign="top" class="textBold">Script Parameters</td>
          <td valign="top" class="text"><ol>
              <li> WebAddress - The URL to which data parameters have to be appended</li>
            <li>LabelListName - The Value List which has to be used for labels</li>
            <li>SeriesListName - The Value List name which has to be used for the 
              Series Names</li>
            <li>DataFieldName - The name of the field which has to be used for value 
              (Summary field)</li>
            <li>GroupByFieldName - The name of the field by which the data has to 
              be grouped first</li>
            <li>GroupByCountField - The name of the count field for the first field</li>
            <li>GroupByFieldName2 - The name of the field by which the data has to 
              be grouped second</li>
            <li>GroupByCountField2 - The name of the count field for the second field</li>
            <li> delimiter - (Optional) The delimiter to be used in this script. This 
              is an optional parameter. The default value used is the one specified 
              in global values when FusionCharts is initialized.</li>
          </ol></td>
        </tr>
        <tr class="tableAlternateDark">
          <td height="77" valign="top" class="textBold">Description</td>
          <td height="77" valign="top" class="text"><p>Constructs the data parameter for multi-series chart by using the SeriesFieldName 
                for seriesName. Moves through records in portal in groups using the GroupByCountField 
                by grouping data with GroupByFieldName field. While moving in groups of 
                GroupByFieldName, performs sub-script to get the data. This sub-script 
                uses GroupByFieldName2 and GroupByCountField2 to move in groups of the 
                GroupByFieldName2</p>
              <p>Uses Value List for creation of labels parameter.</p>
            <p>Assumes that we are in the layout where the data is present and uses 
              GetNthRecord for getting the values. </p>
            <p>Appends zeroes for missing data.</p></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Result</td>
          <td valign="top" class="text"><p>Returns the new web address with the data parameters appended to the 
            given web address</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Run script with full access privileges</td>
          <td valign="top" class="text">Off</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Include In Menu</td>
          <td valign="top" class="text">No</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Layouts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Scripts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr class="tableAlternateHeader textBold">
          <td colSpan="2" valign="top">Script Definition</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Steps</td>
          <td valign="top" class="codeInline"><ul>
              <li>#Author InfoSoft Global (P) Ltd.</li>
            <li>#About the Script</li>
            <li>#----------------------</li>
            <li># Generates data for a multi-series chart. </li>
            <li>#Loops through one field and performs script within this loop,</li>
            <li>#to loop through to get the values for the other field </li>
            <li>#This script requires that the Summary field for Value be given</li>
            <li>#Also requires the CountField for both the fields which are used to 
              group data</li>
            <li>#Assumes that we are in the layout where the data is present in portal</li>
            <li>#Assumes that the data in the layout is already sorted by the two 
              Group By fields</li>
            <li>#Script Parameters </li>
            <li>#----------------------</li>
            <li>#1. WebAddress - The URL to which data parameters have to be appended</li>
            <li>#2. LabelListName - The Value List which has to be used for labels</li>
            <li>#3.SeriesListName - The Value List name which has to be used for the 
              Series Names</li>
            <li>#4. DataFieldName - The name of the field which has to be used for 
              value (Summary field)</li>
            <li>#5. GroupByFieldName - The name of the field by which the data has 
              to be grouped first</li>
            <li>#6. GroupByCountField - The name of the count field for the first 
              field</li>
            <li>#7. GroupByFieldName2 - The name of the field by which the data has 
              to be grouped second</li>
            <li>#8. GroupByCountField2 - The name of the count field for the second 
              field</li>
            <li>#9. delimiter - (Optional) The delimiter to be used in this script. </li>
            <li># This is an optional parameter. The default value used is the one 
              specified in global values when FusionCharts is initialized.</li>
            <li>#Return Value </li>
            <li>#----------------------</li>
            <li>#Returns the new web address with the data parameters </li>
            <li>#appended to the given web address</li>
            <li>Set Variable [ $parameters; Value:Get(ScriptParameter) ]</li>
            <li>Set Variable [ $WebAddress; Value:GetValue($parameters;1) ]</li>
            <li>Set Variable [ $LabelListName; Value:GetValue($parameters;2) ]</li>
            <li>Set Variable [ $SeriesListName; Value:GetValue($parameters;3) ]</li>
            <li>Set Variable [ $DataFieldName; Value:GetValue($parameters;4) ]</li>
            <li>Set Variable [ $GroupByFieldName; Value:GetValue($parameters;5) ]</li>
            <li>Set Variable [ $GroupByCountField; Value:GetValue($parameters;6) ]</li>
            <li>Set Variable [ $GroupByFieldName2; Value:GetValue($parameters;7) ]</li>
            <li>Set Variable [ $GroupByCountField2; Value:GetValue($parameters;8) 
              ]</li>
            <li>Set Variable [ $delimiter; Value:GetValue($parameters;9) ]</li>
            <li># Delimiter value to be used for this chart</li>
            <li>Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) 
              ]</li>
            <li># Go to the last row in the portal</li>
            <li>Go to Portal Row [ Last ]</li>
            <li>#Get the total number of rows</li>
            <li>Set Variable [ $TotalRows; Value:Get(PortalRowNumber) ]</li>
            <li># Initialize variables</li>
            <li>Set Variable [ $labels; Value: Substitute(ValueListItems (Get(FileName); 
              $LabelListName);"&para;";$delimiter) ]</li>
            <li>Set Variable [ $SeriesList; Value:ValueListItems (Get(FileName); $SeriesListName) 
              ]</li>
            <li>Set Variable [ $numberOfSeries; Value:ValueCount(ValueListItems (Get(FileName); 
              $SeriesListName)) ]</li>
            <li>Set Variable [ $numberOfLabels; Value:ValueCount(ValueListItems (Get(FileName); 
              $LabelListName)) ]</li>
            <li>Set Variable [ $labels; Value:"&amp;labels="&amp;$labels ]</li>
            <li>#Append the labels to $DataParams</li>
            <li>Set Variable [ $DataParams; Value:$DataParams&amp;$labels ]</li>
            <li>#Construct a Zero data series that can be used for any missing data</li>
            <li>Set Variable [ $i; Value:1 ]</li>
            <li>Loop</li>
            <li>Exit Loop If [ $i&gt;$numberOfLabels ]</li>
            <li>Set Variable [ $ZeroSeriesData; Value:$ZeroSeriesData &amp;If($i &ne; 
              1;$delimiter;"")&amp; "0" ]</li>
            <li>Set Variable [ $i; Value:$i+1 ]</li>
            <li>End Loop</li>
            <li>Set Variable [ $currentPos; Value:1 ]</li>
            <li>Set Variable [ $loopCounter; Value:0 ]</li>
            <li>Set Variable [ $recordCount; Value:1 ]</li>
            <li># Loop through each row in the portal </li>
            <li>Loop</li>
            <li>Exit Loop If [ $recordCount&gt;$TotalRows ]</li>
            <li># Go to the start row specified in the parameter</li>
            <li>Go to Portal Row [ $recordCount ] [ No dialog ]</li>
            <li>Set Variable [ $loopCounter; Value:$loopCounter +1 ]</li>
            <li>Set Variable [ $seriesName; Value:GetField($GroupByFieldName) ]</li>
            <li>Set Variable [ $SeriesData; Value:"" ]</li>
            <li>#Number of records in this group</li>
            <li>Set Variable [ $summaryVal; Value: GetSummary(GetField($GroupByCountField);GetField($GroupByFieldName)) 
              ]</li>
            <li>Set Variable [ $endRowNumber; Value:$recordCount +$summaryVal ]</li>
            <li>Set Variable [ $foundThisItem; Value:False ]</li>
            <li>#Loop through each item in the SeriesList to see</li>
            <li>#if the current SeriesName is present in the current position</li>
            <li>Loop</li>
            <li>Set Variable [ $tempItem; Value:GetValue($SeriesList;$currentPos) 
              ]</li>
            <li>Exit Loop If [ $foundThisItem or $currentPos &gt; $numberOfSeries 
              ]</li>
            <li>If [ $seriesName=$tempItem ]</li>
            <li># Found the item in the list which corresponds to the current portal 
              row's SeriesName value</li>
            <li>Set Variable [ $foundThisItem; Value:True ]</li>
            <li># For this group, find the values for each field2 by performing script 
              for getting data</li>
            <li>Perform Script [ &ldquo;GetData-LoopThroughPortalInGroups-UseLabelList&rdquo;; 
              Parameter: $LabelListName &amp; "&para;" &amp; $DataFieldName&amp; "&para;" 
              &amp; $GroupByFieldName2 &amp;"&para;" &amp; $GroupByCountField2 &amp; 
              "&para;"&amp;$recordCount&amp;"&para;"&amp;$endRowNumber ]</li>
            <li>Set Variable [ $SeriesData; Value:Get(ScriptResult) ]</li>
            <li>#Prepend the seriesData generated by the subscript with &amp;data= 
              ...</li>
            <li>Set Variable [ $SeriesData; Value:"&amp;data=[seriesName="&amp;$seriesName&amp; 
              $delimiter&amp;"parentYAxis=P"&amp;"]"&amp;$SeriesData ]</li>
            <li>Set Variable [ $foundThisItem; Value:True ]</li>
            <li>Else</li>
            <li># Since there are no values for this item in the portal, initialize 
              zeroes with this series name</li>
            <li>Set Variable [ $SeriesData; Value:"&amp;data=[seriesName="&amp;$tempItem&amp; 
              $delimiter&amp;"parentYAxis=P"&amp;"]"&amp; $ZeroSeriesData ]</li>
            <li>End If</li>
            <li># The current position in the series list is incremented by 1</li>
            <li>Set Variable [ $currentPos; Value:$currentPos+1 ]</li>
            <li>End Loop</li>
            <li># $recordCount is assigned the value of $endRowNumber </li>
            <li># Thus, we move to the next row which corresponds to the next group</li>
            <li>Set Variable [ $recordCount; Value:$endRowNumber ]</li>
            <li>Set Variable [ $DataParams; Value:$DataParams&amp;$SeriesData ]</li>
            <li>End Loop</li>
            <li># After looping through all the portal rows, check if there are any 
              items left in the list</li>
            <li># If so, append zeroe series data for each one of them</li>
            <li>Loop</li>
            <li>Exit Loop If [ $currentPos &gt; $numberOfSegments ]</li>
            <li>Set Variable [ $tempItem; Value:GetValue($SeriesList;$currentPos) 
              ]</li>
            <li>Set Variable [ $SeriesData; Value:"&amp;data=[seriesName="&amp;$tempItem&amp; 
              $delimiter&amp;"parentYAxis=P"&amp;"]"&amp; $ZeroSeriesData ]</li>
            <li>Set Variable [ $DataParams; Value:$DataParams&amp;$SeriesData ]</li>
            <li>Set Variable [ $currentPos; Value:$currentPos+1 ]</li>
            <li>End Loop</li>
            <li>Set Variable [ $NewWebAddress; Value:$WebAddress &amp; $DataParams 
              ]</li>
            <li>#Return the new web address with the labels and data appended</li>
            <li>Exit Script [ Result: $NewWebAddress ]</li>
          </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Scripts used in this script</td>
          <td valign="top" class="text"><ul>
              <li><a href="#GetData_LoopThroughPortalInGroups_UseLabelList">GetData-LoopThroughPortalInGroups-UseLabelList</a></li>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Pre-requisites for this script</td>
          <td valign="top" class="text"><p>WebAddress parameter already has first set of parameters in the QueryString 
              starting with ?. </p>
            <p>We are in the layout where the data is present in portal. Uses data from 
              the active portal. The Value List identified by LabelListName is present 
              in the same fp7 as this script.</p>
            <p>Note that this script needs to be imported/copy-pasted as mentioned in 
              the <span class="codeInline">Script Usage</span>.</p>
            <p>The data is sorted by GroupByFieldName and GroupByFieldName2. </p>
            <p>Count field(GroupByCountField) is defined for the field (GroupByFieldName) 
              by which data is sorted. Count field is a summary field defined as the 
              count of a unique field, summary restarted for each group when sorted 
              by a GroupByFieldName field. The data has to be sorted by this GroupByFieldName 
            field. Similarly with GroupByCountField2 and GroupByFieldName2.</p></td>
        </tr>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="100%" class="tableAlternate" cellpadding="5" cellspacing="1">
      <tbody>
        <tr  class="tableAlternateHeader textBold">
          <td width="32%" valign="top">Script Name</td>
          <td width="68%" valign="top"><a name="GetData_LoopThroughPortalInGroups_UseLabelList"/><span class="codeInline">GetData-LoopThroughPortalInGroups-UseLabelList</span></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Usage</td>
          <td valign="top" class="text"><p>Can be Imported/Copy-Pasted.</p>
            <p>Preferred Usage: Import</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Category</td>
          <td valign="top" class="text">FusionCharts Data Parameters Helper Scripts</td>
        </tr>
        <tr >
          <td valign="top" class="textBold">Script Parameters</td>
          <td valign="top" class="text"><ol>
              <li> WebAddress - The URL to which data parameters have to be appended</li>
            <li>DataFieldName - The name of the field which has to be used for value 
              (Summary field)</li>
            <li>GroupByFieldName - The name of the field by which the data has to 
              be grouped first</li>
            <li>GroupByCountField - The name of the count field for the first field</li>
            <li> startNum - The record number where the looping has to begin</li>
            <li> endNum - The record number where the looping has to end (this last 
              row is not included)</li>
            <li> delimiter - (Optional) The delimiter to be used in this script. This 
              is an optional parameter. The default value used is the one specified 
              in global values when FusionCharts is initialized.</li>
          </ol></td>
        </tr>
        <tr class="tableAlternateDark">
          <td height="77" valign="top" class="textBold">Description</td>
          <td height="77" valign="top" class="text"><p>Scans the portal rows and gets the values separated by delimiter. Moves 
                through records in portal in groups using the GroupByCountField by grouping 
                data with GroupByFieldName field. While moving in groups of GroupByFieldName, 
                gets the value for DataFieldName field. </p>
              <p>Assumes that we are in the layout where the data is present in portal 
              and uses the data from the active portal.</p>
            <p>Appends zeroes for missing data.</p></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Result</td>
          <td valign="top" class="text"><p>Returns the delimiter separated values for the DataFieldName field in 
            all the groups.</p></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Run script with full access privileges</td>
          <td valign="top" class="text">Off</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Include In Menu</td>
          <td valign="top" class="text">No</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Layouts that use this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Scripts that use this script</td>
          <td valign="top" class="text"><ul>
              <li><a href="#BuildAndAppendMSDataParams_LoopThroughPortalInGroups">BuildAndAppendMSDataParams-LoopThroughPortalInGroups</a></li>
          </ul></td>
        </tr>
        <tr class="tableAlternateHeader textBold">
          <td colSpan="2" valign="top">Script Definition</td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Script Steps</td>
          <td valign="top" class="codeInline"><ul>
              <li>#Author InfoSoft Global (P) Ltd.</li>
            <li>#About the Script</li>
            <li>#----------------------</li>
            <li>#Generates multi-series data</li>
            <li># This script is used for scanning the portal rows and getting the 
              values separated by delimiter</li>
            <li>#Assumes that we are in the layout where the data is present in portal</li>
            <li>#and uses the values from Active portal</li>
            <li>#Assumes that the portal is sorted accordingly</li>
            <li>#Script Parameters </li>
            <li>#----------------------</li>
            <li>#1. LabelListName - The Value List which has to be used for labels</li>
            <li>#2. DataFieldName - The name of the field which has to be used for 
              value</li>
            <li>#3. GroupByFieldName - The name of the field by which the data is 
              grouped</li>
            <li>#4. GroupByCountField - The name of the summary field which gives 
              the count</li>
            <li>#5. startNum - The record number where the looping has to begin</li>
            <li>#6. endNum - The record number where the looping has to end (this 
              last row is not included)</li>
            <li>#7. delimiter - (Optional) The delimiter to be used in this script. </li>
            <li># This is an optional parameter. The default value used is the one 
              specified in global values when FusionCharts is initialized.</li>
            <li>#Return Value </li>
            <li>#----------------------</li>
            <li>#Returns the delimiter separated values for this field (all groups)</li>
            <li>Set Variable [ $delimiter; Value:";" ]</li>
            <li>Set Variable [ $parameters; Value:Get(ScriptParameter) ]</li>
            <li>Set Variable [ $LabelListName; Value:GetValue($parameters;1) ]</li>
            <li>Set Variable [ $DataFieldName; Value:GetValue($parameters;2) ]</li>
            <li>Set Variable [ $GroupByFieldName; Value:GetValue($parameters;3) ]</li>
            <li>Set Variable [ $GroupByCountField; Value:GetValue($parameters;4) ]</li>
            <li>Set Variable [ $startNum; Value:GetAsNumber(GetValue($parameters; 
              5)) ]</li>
            <li>Set Variable [ $endNum; Value:GetAsNumber(GetValue($parameters; 6)) 
              ]</li>
            <li>Set Variable [ $delimiter; Value:GetValue($parameters;7) ]</li>
            <li>Set Variable [ $delimiter; Value:If(IsEmpty($delimiter);$$delimiter;$delimiter) 
              ]</li>
            <li>Set Variable [ $recordCount; Value:$startNum ]</li>
            <li>Set Variable [ $currentPos; Value:1 ]</li>
            <li>Set Variable [ $LabelList; Value:ValueListItems(Get(FileName);$LabelListName) 
              ]</li>
            <li>Set Variable [ $TotalItems; Value:ValueCount ($LabelList) ]</li>
            <li>#Loop through the records</li>
            <li>Loop</li>
            <li>Exit Loop If [ $recordCount &ge; $endNum ]</li>
            <li>Go to Portal Row [ $recordCount ] [ No dialog ]</li>
            <li>Set Variable [ $totalValueForGroup; Value:GetField($DataFieldName) 
              ]</li>
            <li>Set Variable [ $currentItem; Value:GetField($GroupByFieldName) ]</li>
            <li># Loop through the valueList and check if this item is in the right 
              position of SeriesData, if not append zeroes</li>
            <li>Set Variable [ $foundItem; Value:False ]</li>
            <li>Loop</li>
            <li>Exit Loop If [ $foundItem or $currentPos&gt;$TotalItems ]</li>
            <li>If [ $SeriesData="" ]</li>
            <li>Set Variable [ $delim; Value:"" ]</li>
            <li>Else</li>
            <li>Set Variable [ $delim; Value:$delimiter ]</li>
            <li>End If</li>
            <li>Set Variable [ $tempItem; Value:GetAsNumber(GetValue($LabelList;$currentPos)) 
              ]</li>
            <li>If [ $tempItem=$currentItem ]</li>
            <li>Set Variable [ $SeriesData; Value:$SeriesData &amp;$delim&amp;$totalValueForGroup 
              ]</li>
            <li>Set Variable [ $foundItem; Value:True ]</li>
            <li>Else</li>
            <li># Appending zeroes for the values that are not found</li>
            <li>Set Variable [ $SeriesData; Value:$SeriesData&amp;$delim&amp;"0" ]</li>
            <li>End If</li>
            <li>Set Variable [ $currentPos; Value:$currentPos+1 ]</li>
            <li>End Loop</li>
            <li># Set $recordCount value such that we move to the next Group in the 
              portal</li>
            <li>Set Variable [ $summaryVal; Value: GetSummary ( GetField($GroupByCountField);GetField($GroupByFieldName)) 
              ]</li>
            <li>Set Variable [ $recordCount; Value:$recordCount +$summaryVal ]</li>
            <li>End Loop</li>
            <li># Loop to add zeroes for missing data after looping through all rows 
              for that group.</li>
            <li>Loop</li>
            <li>Exit Loop If [ $currentPos&gt;$TotalItems ]</li>
            <li>Set Variable [ $SeriesData; Value:$SeriesData&amp;$delim&amp;"0" ]</li>
            <li>Set Variable [ $currentPos; Value:$currentPos+1 ]</li>
            <li>End Loop</li>
            <li>#Return the delimiter separated data for all the groups of this field</li>
            <li>Exit Script [ Result: $SeriesData ]</li>
          </ul></td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold">Scripts used in this script</td>
          <td valign="top" class="text"><ul>
          </ul></td>
        </tr>
        <tr>
          <td valign="top" class="textBold">Pre-requisites for this script</td>
          <td valign="top" class="text"><p>WebAddress parameter already has first set of parameters in the QueryString 
              starting with ?. </p>
            <p>We are in the layout where the data is present in portal and that portal 
              is the active portal.</p>
            <p>Portal has to be sorted by GroupByFieldName field.</p>
            </td>
        </tr>
      </tbody>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div align="left" class="header" ><span class="header1 whiteText">File References</span><a name="FileReferences"/><span class="header1 whiteText"> </span></div></td>
  </tr>
  <tr>
    <td><table width="100%"  class="tableAlternate" cellpadding="5" cellspacing="1">
      <tbody>
        <tr class="chartheaders">
          <td width="22%" valign="top" class="textBold">File Reference</td>
          <td width="78%" valign="top" class="text">File Path List (in search order)</td>
        </tr>
        <tr class="tableAlternateDark">
          <td valign="top" class="textBold"><a name="FusionChartsLibrary"/>FusionCharts Library</td>
          <td valign="top" class="text">file:<span class="codeInline">FusionCharts Library.fp7</span></td>
        </tr>
      </tbody>
    </table></td>
  </tr>
</table>


<p>&nbsp;</p>
</body>
</html>
